Graphs in Excel Moved to PP

K

K. E. McClure

Greetings to All, For Office 2003: I'm making graphs in excel and copying
them onto slides in PP. 4 graphs per slide. I used to just cut & paste but
I found cut & special paste & inserting as a picture works out better for my
purpose. However, I can make graphs in Excel & check all fonts (legend, X/Y
axis) to ensure all fonts should match, for instance, all of the labels for
the axis are 10 Pt Normal, aerial; but when I paste the graphs to PP (on the
same slide) the font sizes rarely look the same. Something always looks
bolder or bigger, or more compact. The graphs on the Slide are appx the
same size so i dont think its a "this one's bigger than that one at the
destination" issue. I'm not sure if this is a PP ? or an Excel ? but I've
given up and am looking for help. I've gone to painful extremes in excel to
make sure all the data in the spreadsheet is the same size, the column & row
headings are the same font & still, the charts I move to PP do whatever they
want. I can even make 2 charts on the same spreadsheet and when I move them
to PP, the look different. I have noticed at times when copying the chart
from the worksheet, that when I click copy, the chart re-sizes it self. I'm
at a loss. Any assistance is appreciated

Kenny
 
E

Echo S

This is very frustrating, I know.

In Excel, make sure you turn off Autoscale on the font menu. (I find it
easiest to do this by selecting the chart area, Format | Font, and unticking
it for everything at once. It's on by default and can be the culprit for
some of what you describe.

After pasting into PPT, make sure the charts / images are the same size.
Right-click the object on the slide, choose Format Object, and on the Size
tab, specify a size %. You'll usually want those to be in proportion /
maintain the aspect ratio -- 100% x 100%, or smaller if necessary, but make
sure they're the same % in both width and height.
 
J

john

If you use paste special you should be able to double click on the chart and
then you can right click on any of the labels, background, axis etc just like
in excel and format fonts colours, styles, fonts etc. You can then srt these
to what you want.
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top