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" wrote:

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 wrote:

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?

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
_______


"Albie" wrote in message
...
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" wrote:

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 wrote:

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?

Sweet, that is simple!

"Jon Peltier" wrote:

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
_______


"Albie" wrote in message
...
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" wrote:

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 wrote:

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?