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?