In Excel 2003 and older, select the chart, Tools, Options, Chart, Plot empty
cells as: Not plotted (leave gaps), or maybe you might prefer Interpolated.

In Excel 2007 search "Not plotted" in help

Regards,
Peter T

"Doug" wrote in message
...
How can I have the chart skip Zero values?
I am using the formula below to leave the cell blank for values that are
zero, but it still shows up in the chart messing up the line.
Is there a chart setting for this or do I need to change the formula?
=IF(N454=0,"",N454*4+150000)
--
Thank you!