A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Hiding parts of a curve on a chart



 
 
Thread Tools Display Modes
  #1  
Old September 28th, 2004, 02:24 PM
Michael Preminger
external usenet poster
 
Posts: n/a
Default Hiding parts of a curve on a chart

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
  #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


  #3  
Old September 29th, 2004, 01:44 PM
Bernard Liengme
external usenet poster
 
Posts: n/a
Default

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




  #4  
Old September 29th, 2004, 10:48 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default

Hi Bernard -

This is appropriate and expected behavior when you choose the "Vary Color by Point"
option. And it only happens if there is a single series, because with two series it
becomes complicated. I recently discovered that manually formatting one point
differently than the rest also induces the legend with each point. I hadn't noticed
the change to the legend when I tried it out yesterday, but this is what you have
described, and it is what I just observed in a follow up trial. Although the legend
changes, the Vary Color by Point box doesn't check itself. So this is a bit of an
inconsistency.

But like you said, who needs a legend with one series? I usually have several series
in my charts, and whenever possible I use other techniques than the legend to
identify the data.

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

Bernard Liengme wrote:
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?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting Charts in a Macro Herman Merman Charts and Charting 1 August 18th, 2004 12:25 AM
Cost curve chart Tushar Mehta Charts and Charting 0 June 9th, 2004 08:48 PM
Chart menu visible property Sandy V Charts and Charting 8 May 17th, 2004 01:39 PM
Data from the curve of a chart Dave Young Charts and Charting 1 November 19th, 2003 01:48 PM
Styles for chart Debra Dalgleish Charts and Charting 1 October 3rd, 2003 12:27 PM


All times are GMT +1. The time now is 02:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.