No, it's not that easy nor is it dynamic. You could hide the entire
stretches where there are only zeros, since by default hidden cells are not
plotted.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"kippers" wrote in message
...
Jon,

Thanks for the advice- they are simply zero values with no formula
attached.
However, there are a lot of elements (series) (20-30) so when the graph is
generated it has large gaps where zero values exist. I was wonderign if
there
was a way in which elements or series that have a zero value could be
eliminated fromt he graph itself (i.e. the actual series header on the
grpah
would not even appear and teh graph would show only those series with a
value
0?)

Cheers,

Paul

"Jon Peltier" wrote:

Are they zero values, or formulas that return zero? If they are zeros,
delete the zeros. If they are formulas, change the formula from

=A1

to

=IF(A1="",NA(),A1)

NA() leaves an error in the cell (#N/A) but doesn't appear on a line or
XY
chart. You can use conditional formatting to hide the error.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"kippers" wrote in message
...
Is it possible to automatically 'ignore' zero values when plotting a
chart.
i.e. any data set with a value of zero would simply not be displayed on
the
chart?