Thanks - This works perfectly. The only problem is that, apparently, when
there is no value for a particular series, then the colors for those pie
sectors are assigned to the next series.

So, for instance, if in a groupA there are men, women and children, the pie
chart colors are blue, red and green. In groupB if women happen to be absent,
then men stay blue, but children become red.

This would be fine, but in my case, charts are side by side and need to be
compared.

I guess I can't have everything, huh? Thanks though.. it'll be a good
solution to apply another time.

Thanks!

"Arvi Laanemets" wrote:

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