Data Labels

[Guest]

On the Chart Options there is an option DATA LABELS. This option lets you
print the following VALUE, PERCENT, LABEL and LABEL + PERCENT. Is there any
way that you can print the Value and the Label. Or is there anyway you can
modify any part of what you want to print beside the section of the pie chart.

 

[Jon Peltier]

You can manually change the text within each data label. This is rather
tedious, so you can download one of the following Excel add-ins, which
allow you to select a worksheet range to use as labels for your points;
both are free, easy to install and use. If you want any particluar
label, you can write a formula in a range of cells that concatenates the
value and the label, then use this range for the labels.

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com/ss

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______