Existing Excel 2003 chart into PowerPoint 2003

[Guest]

Hi,

We have a complex workbook with many charts in it, which we often need to
report into PowerPoint. Having tried all of the usual methods - insert
object, the various paste special options etc, some of the charts appear in
PowerPoint with huge text and a tiny plot area so the text obscures the
chart. The charts look great in Excel - the ones we're mainly having
problems with are an area/bar combo, and they print great on A4, look good in
Excel, but will not display correctly in PowerPoint. Someone has taken a lot
of time to create these charts and are not happy with the suggestion I made
of importing the Excel data into the PowerPoint datasheet and starting again
in PowerPoint. The source data for the charts is quite large. There is also
a preference (not essential, but preferred) for the charts to be linked back
to their source.

Does anyone have any suggestions as to how we can make this work better. Any
help would be greatly appreciated.

Thanks,

Karen

 

[Glen Millar]

Hi Karen,

Have a look at this information on stuff getting cut off or mucked up:

Excel info cut off or cropped when pasted into PowerPoint
http://www.pptfaq.com/FAQ00068.htm


This might help as well:

Problems with LINKED EXCEL CHARTS in PowerPoint
http://www.pptfaq.com/FAQ00067.htm


--

Regards,

Glen Millar
Microsoft PPT MVP

Tutorials and PowerPoint animations at
www.pptworkbench.com

glen at pptworkbench dot com

Please tell us your PowerPoint / Windows version,
whether you are using vba, or
anything else relevant

 

[justin.paton]

Try copy the chart to word then copy the chart that you pasted into
word into powerpoint seems to work with Office 2003. Very weird I know
but just came across it by accident really

 

[Guest]

Hi Glen,

Thanks very much for that. I'll have a good read through and give the
suggestions a try. The charts I'm working with are all on their own
individual chart sheets within the Excel workbook, and I know that these
articles suggest they should be. I'll let you know how I get on with this.

Many thanks,

Take care,

Karen

 

[Echo S]

Copy the chart in Excel, then use Edit | Paste Special in PPT and choose WMF
or EMF (or even PNG). Those all should give you a pretty clean image of the
chart.

If an image isn't going to work for whatever reason, make sure that you've
turned autoscale fonts off on the chart in Excel. (Right-click | Format
Chart Area | Font -- if the font sizes on stuff are all different, you may
need to do this on individual items and not on the entire chart area.)

Then Edit | Paste Special in PPT. (Don't paste into a placeholder or
anything.) Choose Excel Workbook Object. Make sure the chart object is sized
properly by right-clicking it on the slide and choosing Format Object. On
the Size tab, set to 100% x 100%. If it's huge, then double-click to
activate the chart and then drag the edges to resize it on the slide.

Also, see what you have ticked in PPT under Tools | Options | Edit. "New
Charts Take on PPT Font" might be causing some problems, especially if you
*don't* want the font to update to the PPT presentation font. So try
unchecking that box.

 

[Guest]

Thanks Justin. I'll give that a go too. Yes, it's weird, but this is office
03, and everything must be worth a try.

Thanks again.

Take care,

Karen