| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Pivot Chart Series Lists - Limit selections | Excel Discussion (Misc queries) | |||
| Drop down lists for charts | Excel Discussion (Misc queries) | |||
| vlookup & combo box charts | Charts and Charting in Excel | |||
| advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
| restricting the drop lines to only a single series | Charts and Charting in Excel | |||
Linear Mode
