charts and drop down lists

R

Ry

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Drop down lists in seperate columns 5
Excel 2007 charts: want to avoid zero values 1
Adding a line to a population bar chart 0
Graph to display Range Label and Mean 0
Excel line chart not displaying correctly 1
Trendlines: When They Will Be Generated, And When They Will Not BeFor A Scatter Chart 0
Chart with differing x axis 1

Top