How do I hide 0 values in line charts

[Stephan]

I have several columns with data. In one column I do not have data for every
row. In the line charts, those "zero" values are plotted and connected with
the previous data point. Instead I would rather have a broken line.

 

[John Mansfield]

These resources will help:

Andy Pope's tutorial:

http://www.andypope.info/charts/brokenlines.htm

Tushar Mehta's Chart Gap for NA

http://www.tushar-mehta.com/excel/software/na_discontinuity/index.html

 

[Jerry W. Lewis]

Or see

http://groups-beta.google.com/group/microsoft.public.excel.charting/msg/cb16be6a0805c18e

for additional information.

Jerry