Results 1 to 2 of 2
2011-04-07, 16:30 #1
- Join Date
- Apr 2011
- Thanked 0 Times in 0 Posts
Way (VBA or other) to lock pie chart labels in place
I'm using Excel 2002. I have a number of pie charts with a lot of information, so the charts get crowded. I spent a long time moving around the labels and leader lines so that everything is just right. When I try to update my values, however, the labels and lines go haywire and end up overlapping each other or moving off the screen (i.e. I believe they are returning to their original positions). Is there a way to lock/freeze the data label positions in my charts so that when I update the values, the labels and leader lines will not move?
Thanks a lot.
2011-04-07, 16:41 #2
- Join Date
- Dec 2000
- Burwash, East Sussex, United Kingdom
- Thanked 198 Times in 184 Posts
My first suggestion would be: don't use a pie chart.
If you have more than two or perhaps three slices, it's 99% probable that it's the wrong chart type, especially given your current problem. At a guess I'd say a bar chart would be better, but without seeing the data it's impossible to be sure. (you may enjoy Jon Peltier's blog post here.)Regards,
Microsoft MVP - Excel