MS 2007 Excel Pie Charts

[Raysns]

I created an MS 2007 Excel Pie Chart with the appropriate data and labels. Some of the data have zero values. I am trying to figure out how I can exclude zero values from showing up on the chart. However, because the data changes frequently, I need to maintain the label/series. Appreciate any advice on this topic.

Thanks

[Andy Pope]

Depending on your data labels a custom number format may work.

general;;;

This article has other suggestions about custom data labels.
http://pubs.logicalexpressions.com/P...cle.asp?ID=390