A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Graphs in Excel Moved to PP



 
 
Thread Tools Display Modes
  #1  
Old February 28th, 2007, 12:30 AM posted to microsoft.public.excel.setup,microsoft.public.powerpoint
K. E. McClure
external usenet poster
 
Posts: 2
Default Graphs in Excel Moved to PP

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


  #2  
Old February 28th, 2007, 12:37 AM posted to microsoft.public.excel.setup,microsoft.public.powerpoint
Echo S
external usenet poster
 
Posts: 7,403
Default Graphs in Excel Moved to PP

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.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/

"K. E. McClure" wrote in message
...
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



  #3  
Old February 28th, 2007, 09:43 AM posted to microsoft.public.excel.setup,microsoft.public.powerpoint
John
external usenet poster
 
Posts: 2,649
Default Graphs in Excel Moved to PP

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)


"K. E. McClure" wrote:

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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:28 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.