Hi Andy,

I have sometimes felt that this should be labelled as a bug in Excel. Column
charts correctly leave gaps, but line and scatter charts do not. As you say,
only the markers are not plotted, but the lines are still there.

A possible workaround (which works only in Excel 2007) is to use a 3d line
chart with angles and perspective set to zero. This correctly leaves a gap
in the middle, and looks pretty close to a 2d line chart.

Ed Ferrero
www.edferrero.com

Hi,

What exactly does 'not working' mean? What type of chart?

The use of NA() in a line chart will only suppress the displaying of a
data marker. The line will be interpolated between real data points.
http://www.andypope.info/charts/brokenlines.htm

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel