Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Apr 2011
    Thanked 0 Times in 0 Posts

    Way (VBA or other) to lock pie chart labels in place

    Hi everyone.

    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.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Burwash, East Sussex, United Kingdom
    Thanked 228 Times in 210 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.)

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts