charts and drop down lists

[Guest]

I have data for 6 different groups. I want to create 1 line graph that shows
this data by quarter - however I want to have a drop down so that when you
select a certain group then only that group's data shows up in the chart. I
know how to do data validation but I can't seem to put "IF" statements into a
data range for the chart. I've seen this done before but I don't know how.
Any ideas?

 

[Debra Dalgleish]

Jon Peltier has instructions for selecting a series in a combo box:

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