Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I quickly export 90 diff versions of 1 .xls chart in ppt?
I am running different scenario's in excell. The result of a scenario is
shown in one chart. How can I quickly export this same chart to powerpoint in a way that I get the 90 charts for the different scenario's in one powerpoint presentation. I don't want to have to copy and past all the charts, and I would also prefer powerpoint to alway copy the next chart at the end of the presentation. Thanks! Maurik |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I quickly export 90 diff versions of 1 .xls chart in ppt?
One thing you might try is to open a blank PPT presentation and record a
macro that pastes in your chart object the way you want it. Then write an Excel macro that, depending on how you're doing the charts, copies the chart and pastes it into PPT. If you're doing one chart and pasting, one chart and pasting, then you'd probably want to identify the PPT file by name somehow so you don't have to browse for it every time. If you're going to do all 90 charts at once, and then paste into PPT (I think I would try this way), then you can create a new 90-slide PPT, and cycle through charts and PPT using For i = 1 to 90, copy chart i and paste into slide i. HTH Ed "Maurik" wrote in message ... I am running different scenario's in excell. The result of a scenario is shown in one chart. How can I quickly export this same chart to powerpoint in a way that I get the 90 charts for the different scenario's in one powerpoint presentation. I don't want to have to copy and past all the charts, and I would also prefer powerpoint to alway copy the next chart at the end of the presentation. Thanks! Maurik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare two versions of the same spreadsheet to see diff. | Excel Discussion (Misc queries) | |||
Using same VBA program in diff. Excel versions. | Excel Programming | |||
Diff versions of Excel! | Excel Programming | |||
Windows versions diff | Excel Programming |