Is it possible at all?
Hi All,
So I have 3 worksheets full of graphs. The idea was to create many of them and let the user choose 3-5 most interesting. So I set up new worksheet which is supposed to be 'final destination' worksheet where finally selected graph should appear. Is there any more convenient way to do so than copy-paste? lucas |
Is it possible at all?
You could construct a UI for the users that lets them choose which charts to
show or which data to chart. It would be an extension of these: http://peltiertech.com/Excel/Charts/ChartByControl.html http://peltiertech.com/Excel/Charts/...eDropDown.html It's more convenient for the user, but not for the programmer! - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "lucas" wrote in message ... Hi All, So I have 3 worksheets full of graphs. The idea was to create many of them and let the user choose 3-5 most interesting. So I set up new worksheet which is supposed to be 'final destination' worksheet where finally selected graph should appear. Is there any more convenient way to do so than copy-paste? lucas |
Is it possible at all?
Thanks!
"Jon Peltier" wrote: You could construct a UI for the users that lets them choose which charts to show or which data to chart. It would be an extension of these: http://peltiertech.com/Excel/Charts/ChartByControl.html http://peltiertech.com/Excel/Charts/...eDropDown.html It's more convenient for the user, but not for the programmer! - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "lucas" wrote in message ... Hi All, So I have 3 worksheets full of graphs. The idea was to create many of them and let the user choose 3-5 most interesting. So I set up new worksheet which is supposed to be 'final destination' worksheet where finally selected graph should appear. Is there any more convenient way to do so than copy-paste? lucas |
All times are GMT +1. The time now is 08:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com