Allow show/hide option for Excel graph series
 

To plot a graph with multiple series in Excel, I need to "Add" each series in
the Source Data window. When I get to several series (5+), it gets difficult
to organize the graph. I would like to select specific series to show and
deselect specific series to hide, all at my choosing. This would make it
very easy to show comparisons between Series A and B, followed by a
comparison in Series B and C, etc. Meanwhile, I could have a few series
permanently shown on the graph as reference data.
As it is now, in order to make the comparisons, I have to create several
different graphs or I have to add and remove series within the same graph.
Adding a series requires selecting the data columns from the spreadsheet; if
the spreadsheet is large, this can be a big pain to do over and over again.
Both methods are a hassle and not efficient for the user. Please add
click-able hide/show options.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

Allow show/hide option for Excel graph series
 

Margaret -

You could use checkboxes linked to each series to make it easy to show or
hide certain ones:

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

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


"Margaret from Michigan" <Margaret from
wrote in message ...
To plot a graph with multiple series in Excel, I need to "Add" each series
in
the Source Data window. When I get to several series (5+), it gets
difficult
to organize the graph. I would like to select specific series to show and
deselect specific series to hide, all at my choosing. This would make it
very easy to show comparisons between Series A and B, followed by a
comparison in Series B and C, etc. Meanwhile, I could have a few series
permanently shown on the graph as reference data.
As it is now, in order to make the comparisons, I have to create several
different graphs or I have to add and remove series within the same graph.
Adding a series requires selecting the data columns from the spreadsheet;
if
the spreadsheet is large, this can be a big pain to do over and over
again.
Both methods are a hassle and not efficient for the user. Please add
click-able hide/show options.