Re: Allow show/hide option for Excel graph series
 From: "Jon Peltier" <jonxlmvpNO@xxxxxxxxxxxxxxxxxxx>
 Date: Mon, 13 Aug 2007 14:51:09 0400
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 Michigan@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message news:B23488ADC6CB412AB6842BEAA7D4A8C3@xxxxxxxxxxxxxxxx
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
clickable hide/show options.
.
 Prev by Date: Re: Pie Chart margins  can you reduce them?
 Next by Date: Re: Embedding an annotation or a comment to a chart in Excel 2007
 Previous by thread: Re: Charts that ignore certain data
 Next by thread: Re: Weight conversion
 Index(es):
Relevant Pages
