Power Point Chart linked to Excel Chart

Hi,
I haven't really attempted this yet but i have to build this presentation on a weekly basis (dammit!) and it needs graphs etc..

I know you can link it to a spreadsheet..

Does anyone have any examples that they have?

Also, is there a way for the data in power point to only update when the "Update button" is clicked?
Because i know it updates automatically when data in the spreadsheet is changed...but i dont necessarily want that, i want to see the changes happen in front of my when i click "update"....

does anyone have any websites or anything in relation to this?

Hi
One way to do this is to copy the chart in a saved Excel workbook, then in PowerPoint select edit! Pastespecial! Pastelink. This should paste the chart as a linked excel chart object. You can then pick edit! Links! To set the update settings and update the charts.

However, I find these links a bit slow and unstable, and the resulting file very large. I prefer to create a new PowerPoint presentation each time using this macro from Excel, copying pictures not chart objects, and omitting the links. It’s very quick, even when copying the 300+ charts in one of our spreadsheets.

Note the macro exports every chart on a chart sheet in the active workbook to powerpoint. You must have the microsoft powerpoint object library checked in tools! references!

Please Login or Register  to view this content.

hey, thanks for that
i havent tested it but i will when i have time...

my question is though, when it pastes it into a power point..can u get it to paste onto a specific slide + order + specific location on that power point slide (like exactly on a specific location)?

Hi PD

yes you can

You can run macros from Excel to control the position of the chart etc in PowerPoint. In the macro above, the chart is positioned in the centre of the slide both vertically and horizontally, but you could change that to place it e.g. 20 points from the left and 6 from the top. Placing the chart on the “nth” slide, where n is the number of the chart in the workbook, ensures that the chart is placed on the last slide, but again you could specify a different number.

Andy - thanks for the edits, I'm a bit rusty with my posting etiquette.

Hi,

could i please have an example of the code to place it on a specific location of a slide?

Hi PD

in the above example, the code

PPPres.Slides(n).Shapes.Range.Align msoAlignCenters, True

ensures that each exported chart is placed in the middle of the slide.

You can basically apply any of the code you could use within PowerPoint to place the chart from Excel in this way.

yeah but instead of centering, how can i go to a specific location e.g. x, y etc

instead of the code to align cente etc, you could replace it with this:

Please Login or Register  to view this content.

the numbers are the distance in points from the top and left margins

Excellent,

Another question

I have the following code:

Please Login or Register  to view this content.

Initially instead of adding a new slide. I make the code go to a specific slide number and then paste using the above code. But what this does is it applies

Please Login or Register  to view this content.

to all the objects in that slide such as text boxes etc. How can i just get it to apply the above code just for the picture which i just added.

Please start your own thread.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.