Drop Down List for Chart
 

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.

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


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

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/Cha...ByControl.html

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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html