If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 news 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 |
#3
|
|||
|
|||
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 news 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 |
Thread Tools | |
Display Modes | |
|
|