Convert Excel charts to Power Point

[RompStar]

I have a whole bunch of Excel Charts, my boss wants me to convert them to Powerpoint, because it looks better in that for presentation purposes and I know nothing about power point, I can figure things out by clicking on it, but that's about it...

Is there a tool that will convert a Excel chart to Powerpoint automatically ?

Or is that wishful thinking.

 

[RompStar]

ya that's how it works with our charts, the excel file is updated, the PPT updates the links when you open it, so once the charts are inplace, since we re-use them with just different data for the month, only have to update the cells in excel..

You are right about manual work vs. automation, I am learning that too, but in order to understand automation, one has to understand the manual procedure I think, will make me a better VB person later...

 

[Jon Peltier]

pasting it as picture I don't think will work, because the managers want to able to format the chart with the better charting options that come with powerpoint...

I think you'll find that PowerPoint has inferior chart formatting capabilities compared to Excel. PowerPoint uses MS Graph, which is a rather limited stepbrother to Excel's charting engine.

If you must use MS Graph within PowerPoint, you can certainly automate it. There are pages on Microsoft's web site and on the PowerPoint FAQ site (http://rpdslides.com) which can help.

The VBA paste-link process doesn't work in Office versions prior to XP. Most (or at least half) of my clients use 2000 still, so I simply have the code paste copies of pictures of the charts into their presentations. If they need to update, they change the charts in Excel, then click the button again, and it repastes all the pictures. It's fast enough that they don't notice any delay.

I have some suggestions for working with Excel and PowerPoint on my web site:

http://peltiertech.com/Excel/XL_PPT.html

 

[RompStar]

sounds good, everybody here at work has Office 2003, and it works perfectly, trust me everybody get Office for free around here :- )

MS..