Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic chart: Changing Ranges
Hi:
I have a set of data, going across by months, and going down into different categories that I have to graph using stacked column charts. Since the data is going to be in the same columns, just going down a category...I'd like to know if there is a way for me to add some kind of drop-down to the chart so that users can just drop-down to CATEGORY 1, and see the chart for CATEGORY 1, without me having to build 10 different charts that i'll have to update everytime i add new data. I would appreciate any advice or feedback. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic chart: Changing Ranges
Hello:
Check out Jon Peltier's website. It looks like http://www.peltiertech.com/Excel/Cha...ByControl.html is what you are looking for. GL, Henk "Benihime" wrote: Hi: I have a set of data, going across by months, and going down into different categories that I have to graph using stacked column charts. Since the data is going to be in the same columns, just going down a category...I'd like to know if there is a way for me to add some kind of drop-down to the chart so that users can just drop-down to CATEGORY 1, and see the chart for CATEGORY 1, without me having to build 10 different charts that i'll have to update everytime i add new data. I would appreciate any advice or feedback. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic chart: Changing Ranges
This is great. I don't even have to look up links on my web site any more,
because someone's sure to have beaten me to it! - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "HEK" wrote in message ... Hello: Check out Jon Peltier's website. It looks like http://www.peltiertech.com/Excel/Cha...ByControl.html is what you are looking for. GL, Henk "Benihime" wrote: Hi: I have a set of data, going across by months, and going down into different categories that I have to graph using stacked column charts. Since the data is going to be in the same columns, just going down a category...I'd like to know if there is a way for me to add some kind of drop-down to the chart so that users can just drop-down to CATEGORY 1, and see the chart for CATEGORY 1, without me having to build 10 different charts that i'll have to update everytime i add new data. I would appreciate any advice or feedback. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent user changing pivot chart layout | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |