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 |
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 |