want a break in line graph

[Guest]

I have a line graph with values for years. Between the years 1998 and 1999
there was a coding change so I don't want the line to connect the points for
those two years. I have selected the second point, right clicked and selected
format data point. In the dialog box under the Patterns tab I select none for
the line options. In Excel 2000 and earlier the line would end at the value
for 1998 and start again with the value for 1999. In Excel 2002 and 2003 the
line is not broken and gets connected from 1998 directly to 2000 skipping
1999. This is not the behavior I want and seems like a bug.

 

[Bernard Liengme]

Hi Cathy,
I can get what you seem to need in two ways:
a) use an XY chart rather than Line and format one point to have no line.
However, the legend (if you have one) now shows each data point - odd!
or
b) make an XY chart of the data up to year 1998; now select the data from
1999 to whatever and copy; click on chart to activate and use Edit|Paste
Special and specify New SERIES with category-x values in first column

best wishes
Bernard

 

[Tushar Mehta]

Yes, it's a change introduced with XL2002. I filed a bug report
shortly after 2002 came out. MS, in its collective wisdom, has not
deemed it necessary to address the problem.

--
Regards,

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

 

[Guest]

I thought it was a bug. Thanks, for confirming.
-Cathy

 

[Guest]

I thought this was a bug. Thanks for confirming it.
-Cathy

 

[Guest]

You could also change the color of the line so that it matches the background
color on the chart.