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.

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/so...ity/index.html

----
Regards,
John Mansfield
http://www.pdbook.com

"Stephan" wrote:

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.

Or see

http://groups-beta.google.com/group/...16be6a0805c18e

for additional information.

Jerry

John Mansfield wrote:

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/so...ity/index.html

----
Regards,
John Mansfield
http://www.pdbook.com

"Stephan" wrote:


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.