Drop Down List for Chart

[Guest]

I have grouped my series into several groups. How do I display a drop down
list including the groups which will dynamically identify which series to
plot on the chart?
For example:
Group A = Series 1, Series 2, Series 3
Group B = Series 4, Series 5
Group C = Series 6
Drop down list includes values: "Group A", "Group B", "Group C"
When Group A is selected within the drop down, Series 1, 2 and 3 are plotted
on the chart.

 

[jiwolf]

Do you mean you have to plot data, and have the chart move week to week? if
so, easiest way is to use a hlookup/vlookup

 

[Debra Dalgleish]

Add a Group column to the data table, and indicate which group each
series is in. Then adapt Jon Peltier's checkbox technique, to show a
specific group:

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