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 |
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 |
All times are GMT +1. The time now is 12:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com