Data Labels in Excel Pie Charts

[Marlaine]

How do I get the data labels to stay where I put them in pie charts. I have
a series of pie charts set up and update the data they are based on monthly.
I find that most of the time when I go to the pie chart, whether or not I
have updated the source data, the labels will move and typically so that they
are not able to be read, eg all of them at the top of the form with some on
top of the other.

Is there a way to freeze the data labels so that I dont have to keep
reformatting?

 

[Michael.Tarnowski]

How do I get the data labels to stay where I put them in pie charts.  Ihave
a series of pie charts set up and update the data they are based on monthly.  
I find that most of the time when I go to the pie chart, whether or not I
have updated the source data, the labels will move and typically so that they
are not able to be read, eg all of them at the top of the form with some on
top of the other.

Is there a way to freeze the data labels so that I dont have to keep
reformatting?

Hi Marlaine,

There are some chart label tools available. Maybe a look at
* John Walkenbach's Chart Tools: http://j-walk.com
* Chart label: Rob Bovey's Chart Labeler: http://appspro.com
helps you out.

HTH - cheers, have a nice day
Michael