Hi

In chart source table replace 0's with "#N/A", p.e. through formula
=IF(MyFormula=0,"#N/A",MyFormula)

Probably, when you use actual source table for other purpouses too, this
isn't an option. But you can always have a mirror of actual source table as
source for chart - with 0's replaced.

Arvi Laanemets


"Stilla" wrote in message
...
Is there a way to keep "0%" values ifrom being graphed in a pie chart?
(Besides eliminating the 0's from the source chart, of course).

I have set up some automatically populating tables, and corresponding
charts. I don't want to have to go back and eliminate all the zeros from
the
tables.

Thanks in advance,

Stilla