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

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

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