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