charts and drop down lists
 

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?

charts and drop down lists
 

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

http://www.peltiertech.com/Excel/Cha...ByControl.html

Ry wrote:
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
Contextures
http://www.contextures.com/tiptech.html