Hi Jon,

I just retested versions of XL from 2000 to 2007: created a Line chart and
then tried to format a single point to 'no line'. As of today, in 2002
(SP2?) it still shows the line. I am reasonably sure that was the same
behavior with 2003 when it first came out but today the line disappeared for
the single point. So, it was probably fixed in some 2003 SP.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Tushar -

In which version of Excel did Microsoft make the change?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Tushar Mehta" wrote in message
om...
That's the way MS designed the charting capability. If you are plotting a
XY Scatter chart, check out the add-in at
Chart gap for N/A
http://www.tushar-mehta.com/excel/so...ity/index.html

It used to work with Line charts until MS made a change that messed up how
Line charts deal with breaks in the line.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have found the trick to prevent 0's from showing in a chart when the
data
is blank:

If(H2="",NA(),H2/F2)

However, the chart line extrapolates from the previous data point to the
next datapoint instead of showing a gap. I've looked at
Tools-Options-Chart
and the Active Chart - Plot Empty Cells as "Not Plotted (leave gaps)" is
selected.

The data is being charted on a secondary Y axis if this makes a
difference.
Please help. I need to have gaps.