How do I suppress zero values in a pie chart. i have tried returning
na# instead of zero and I tried using the format General; General,
neither are working for me with pie charts.... the na# appears, and
when I use General; General a dash "-" appears.

By way of explanation - I have a list of customers with a contribution%
against each - i wish to show the postive % customers on one pie chart,
and the negative % csutomers on a second pie chart. i have therefore
created two new % values and used an IF statement to supress postives
on one and negatives on the other. From that I make two graphs...


--
Kevin Gallagher
------------------------------------------------------------------------
Kevin Gallagher's Profile: http://www.excelforum.com/member.php...fo&userid=7459
View this thread: http://www.excelforum.com/showthread...hreadid=335716