Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Define range for graphs/charts with validation list
Hi I would like to change the range for a graph with a dropdown list. See attached picture to get the feeling. I don't want to have 12 charts for each month, but one graph and a validation dropdown list with which I can dictate the graphs' data ranges. If I select January in the dropdown list, I must take the january range for the graph, etc. I do not know if this is possible, but if it is possible that would be an awesome solution. +-------------------------------------------------------------------+ |Filename: example.jpg | |Download: http://www.excelforum.com/attachment.php?postid=3757 | +-------------------------------------------------------------------+ -- janfolmer ------------------------------------------------------------------------ janfolmer's Profile: http://www.excelforum.com/member.php...o&userid=26297 View this thread: http://www.excelforum.com/showthread...hreadid=400017 |
#2
|
|||
|
|||
this sounds as though a pivot table chart would do exactly what you need.
check out help on pivot tables and their charts. "janfolmer" wrote: Hi I would like to change the range for a graph with a dropdown list. See attached picture to get the feeling. I don't want to have 12 charts for each month, but one graph and a validation dropdown list with which I can dictate the graphs' data ranges. If I select January in the dropdown list, I must take the january range for the graph, etc. I do not know if this is possible, but if it is possible that would be an awesome solution. +-------------------------------------------------------------------+ |Filename: example.jpg | |Download: http://www.excelforum.com/attachment.php?postid=3757 | +-------------------------------------------------------------------+ -- janfolmer ------------------------------------------------------------------------ janfolmer's Profile: http://www.excelforum.com/member.php...o&userid=26297 View this thread: http://www.excelforum.com/showthread...hreadid=400017 |
#3
|
|||
|
|||
Jon Peltier has instructions for interactive charts that you could adapt
to your worksheet: http://www.peltiertech.com/Excel/Cha...ByControl.html janfolmer wrote: Hi I would like to change the range for a graph with a dropdown list. See attached picture to get the feeling. I don't want to have 12 charts for each month, but one graph and a validation dropdown list with which I can dictate the graphs' data ranges. If I select January in the dropdown list, I must take the january range for the graph, etc. I do not know if this is possible, but if it is possible that would be an awesome solution. +-------------------------------------------------------------------+ |Filename: example.jpg | |Download: http://www.excelforum.com/attachment.php?postid=3757 | +-------------------------------------------------------------------+ -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Data Validation (in a range of cells) | Excel Worksheet Functions | |||
Define a range based on another named range | Excel Worksheet Functions | |||
Conditional data validation (using a filtered range?) | Excel Worksheet Functions | |||
Range name limit for data validation | Excel Worksheet Functions |