Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing Chart with a lookup
Hi,
I have a spreadsheet with about 15 charts. I want to be able to automatically switch between charts in the "Main" tab based on an input. So for example if I input "1" chart #1 would appear in the "Main" tab. All of the charts are different (they have different units for the X and Y values) so I cannot use a named range (at least I don't know how to use the named range). Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing Chart with a lookup
Jeff -
Try the second approach he http://peltiertech.com/Excel/Charts/...eDropDown.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Jeff" wrote in message ... Hi, I have a spreadsheet with about 15 charts. I want to be able to automatically switch between charts in the "Main" tab based on an input. So for example if I input "1" chart #1 would appear in the "Main" tab. All of the charts are different (they have different units for the X and Y values) so I cannot use a named range (at least I don't know how to use the named range). Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
Changing chart orientation | Charts and Charting in Excel |