Play with lines in one chart

[pacific]

Hi! I have created one X-Y chart for 43 different datas. So there are 43
different colored lines on one chart and it all shows the correct data.
However, I want to show a single line but not the other 42 on the graph
whithout deleting the others. For example; I will show "line 11" and "line
12" while I disappear all the other 41 lines. After that when I need I will
make "line 15" and "line30" visible again and close "line 11" and "line12".
How can I do that?

 

[Jon Peltier]

On this web page I show an example of the use of worksheet controls
(e.g., checkboxes) to select which series appear in a chart:

http://peltiertech.com/Excel/Charts/ChartByControl.html

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

 

[pacific]

Thank you Jon. You really helped me a lot with your answer.

"Jon Peltier":

 

[Albie]

Jon,

I am doing the same thing as the post you replied to, I have gone to you
site listed below and it works great! I want to take it to the next level,
is there a way to do it on the chart itself? I like having a chart on its
own tab and have the series selector in the same location.

Albie

 

[Jon Peltier]

You can use controls from the Forms menu on a chart sheet.

- Jon

 

[Albie]

Sweet, that is simple!

You can use controls from the Forms menu on a chart sheet.

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