One Frame, 10 Charts, 10 Macros?
 

Is there a way to define and display different charts withing the sam
frame(One at a time), by utilizing different marco buttons to selec
the specific charts that are defined by these macros?

Found a trick to lawyer several charts on top of one another by settin
their backgrounds to zero in Office 2004. I then move them aroung wit
macros, but this got very messy.

Any ideas could be helpful.

Thanks, Michae

--
MJSlatter
-----------------------------------------------------------------------
MJSlattery's Profile: http://www.excelforum.com/member.php...fo&userid=1614
View this thread: http://www.excelforum.com/showthread.php?threadid=27761

One Frame, 10 Charts, 10 Macros?
 

Have a look at Jon's examples of changing charts and there content.

http://peltiertech.com/Excel/Charts/ChartByControl.html
http://peltiertech.com/Excel/Charts/...eDropDown.html

MJSlattery wrote:

Is there a way to define and display different charts withing the same
frame(One at a time), by utilizing different marco buttons to select
the specific charts that are defined by these macros?

Found a trick to lawyer several charts on top of one another by setting
their backgrounds to zero in Office 2004. I then move them aroung with
macros, but this got very messy.

Any ideas could be helpful.

Thanks, Michael



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info