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?