View Single Post
  #2  
Old September 28th, 2004, 11:25 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default

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