Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros behind charts | Charts and Charting in Excel | |||
make macros in charts | Charts and Charting in Excel | |||
How to attach legend frame to chart frame? | Charts and Charting in Excel | |||
Macros & pie charts | Charts and Charting in Excel | |||
Pie charts in Macros | Excel Programming |