Font Problems with Excel Charts Pasted into Powerpoint

[Leo Nicholson]

When pasting Excel line charts into Powerpoint (with dates at bottom, not
table), we are having to make the date fonts very large (10-12) to avoid
printing problems (dates print out as solid black areas). Using large fonts
reduces the plot area of chart itself and ends up with small plot area,
large date fonts. I have tested on both HP and Xerox color inkjets (same
problem). The dates view perfectly with smaller fonts onscreen.

I feel our problems may be related to how we are creating the Powerpoint
slides. We make the charts in Excel and paste into Powerpoint as enhanced
metafiles. Within Excel, are there any steps we should be taking to avoid
this problem? The Excel charts exist as multiple charts within a single
worksheet. Would it help to change to 1 chart per worksheet, etc. Any
advice would be sincerely appreciated.

 

[Brian Reilly, MVP]

Leo,
I'd suggest two things. The first may be enough.
1. From the menu choose Tools + Options + Print Tab and check the box
that says "Print inserted objects at printer resolution."

See if that works,

If not, check the scaling of the Excel charts in PPT. They should be
100% of original size. if they are not you should size the charts in
Excel so that when you size them at 100% in PPT the font sizes won't
change.

Brian Reilly, MVP