want a break in line graph
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
"CathyO" wrote in message
...
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.
--
CathyO
|