Have the data you are pulling from be the result of formulas such as
=IF(xyz=0,NA(),xyz)

This means that in place of 0 you will have N/A and that will not be plotted
on the chart (Unless it is one specific type which will still show it -
Can't remember which).

Assume it's a line chart or something similar and you just don't want the
line dropping to the axis for the missing data.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"jhorsley" wrote in
message ...

I'm trying to chart some data into a pie chart automatically once a moth
or so. I just want to add the data and have the chart chart itself.
The problem is that some of the data can come in with a zero value one
month and other months a value above 0. For the months that it comes
in as zero I don't want the chart to graph it.

Is there a way to do this?

Thanks

jhorsley


--
jhorsley
------------------------------------------------------------------------
jhorsley's Profile:
http://www.excelforum.com/member.php...o&userid=26040
View this thread: http://www.excelforum.com/showthread...hreadid=480868