Is there a better way to imbed an Excel Chart? (PP97)

Topic

New Reply

I’m creating a presentation with about 20 Excel charts. I copy the chart from Excel and paste it into PowerPoint, resize the chart, and do it again for the next chart. Is there a more efficient way to bring the charts into PowerPoint so they’re full size? (I have to do this every week — tedious!)

Reply | Quote

Replies

You could use a macro in Excel to do the work for you.

Reply | Quote

Personally – I’d take the Excel data and place it in the PPT datasheet. Charts created this way have a colour scheme that matches the presentation, they don’t need to be resized and just generally look better.

Cheers

Reply | Quote

In PowerPoint 2000, you can link the charts from a workbook by using functions embeded in the object slide layout. It has been awhile since I worked on the 97 version. I hope this will work for your.

You will need to change the slide layout to either a large object or object.
If you are unfamiliar with this, you are able to change the format of each slide from a bullet list to a movie clip slide and several in between. You can find this feature under the menu Format – Slide Layout. I would recommend you use either the large object or object with title layout. When you select either of these layouts, you will see a caption to “double click to add object” on your PowerPoint slide, do that double click and a dialogue box will prompt you for several things.
1. Create from:
a. New
1. Object Type

b. File (You should use this one)
1. Link (Definitely select this one)

2. Display as icon (do not select)

Browse to your Excel file and select it for use and press OK until you are back to your PP slide.
Now you will see your last active worksheet in that workbook displayed on your PP slide.
Double click your Excel worksheet and either create your chart or select the chart tab you want to display.
I recommend that you place the charts on their own worksheet not co-mingled on the data worksheet.

After you are finished with your chart making, Save & Exit from excel and you will notice that your changes did not seem to take effect.
Here’s the trick,
Right click and select ‘update link’ and Whalah!

Your chart now shows in PowerPoint and is linked. So, any changes you make and save to the workbook in the future will automatically update the charts and when you are finished, OPEN the PowerPoint and you will be prompted to updated the links. Select ‘Yes’ and then save your PP. You are now done.

One Workbook – One PowerPoint.
No More Copy, Paste, and Resize.

Reply | Quote