|
Posted to microsoft.public.excel.charting
|
|
|
Play with lines in one chart
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?
|