I wanted to see what you said about lines in XL2003. With a 5 point XY chart
I hid point 4 using format single point.Surprise, the legend changed from a
single y to five items - one for each x-value. The same occurred in a Line
chart. Same happened in XL2000. Very odd.
If the chart had two series, the legend was well behaved. But then who needs
a legend with only one series?
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address
"Jon Peltier" wrote in message
...
Michael -
You can apply different formats to individual points and lines in a
series. Click once to select the series, then again to select a point and
the line connecting it to the previous point. Now choose the Format
Selected Data Point command on the Chart menu or the right-click menu.
You can even use 'None' for the format of a line segment to make it
disappear in an XY Scatter chart. In line charts in Excel 97 and 2000,
this also works. In Excel XP, for some reason Microsoft changed the
behavior, so instead of making one line segment disappear, both segments
attaching to that point disappear, but a new line is drawn from the point
before the select point to the point after.
Instead of 'None' you could pick a line color that matches the background
color.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Michael Preminger wrote:
Hello!
I've done this before, but it's a long time ago, and I forgot how I
accomplished that...
I would like to show a curve, but only some pieces of it.
I mean:
I would like to hide some pieces of the curve, pieces that correspond to
irrelevant intervalls on my x-axis
See for example the two curves he
http://bibin.hio.no/~michaelp/example1.gif
Only three intervalls from a whole value-range are shown.
And again: I cant remember what on earth I did to accomplish it, and I
cannot repeat this for new curves. The entire curve, inclusive the
uninteresting intervalls is shown. Some help would be most appreciated.
Thanks
Michael