Can I add values, labels and percentage for pie charts?

[coops-eng]

I am using Excel 2000 to give a detailed breakdown analysis of machine
performance. I would like to be able to display my pie charts showing the
Label, value and the percentage all at the same time. I also need if possible
to avoid showing this information for segments of the pie that have no data,
to provide a clear and un-cluttered chart?

Can this be done with the current version of Excel I am using?

 

[Andy Pope]

Hi,

With xl2k you can get percent and label.
You can create a helper column where you concatenate the required
information and then link the data labels to the cells.

Use Rob Bovey's free addin, Chart Labeler, to make this easier.
http://www.appspro.com/Utilities/ChartLabeler.htm

Check out Jon Peltier's article on pie charts,
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=390

and to remove zero's and legend entries see this example.
http://www.andypope.info/charts/piezeros.htm

Cheers
Andy