Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup,microsoft.public.powerpoint
external usenet poster
 
Posts: 1
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   Report Post  
Posted to microsoft.public.excel.setup,microsoft.public.powerpoint
external usenet poster
 
Posts: 2
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   Report Post  
Posted to microsoft.public.excel.setup,microsoft.public.powerpoint
external usenet poster
 
Posts: 2,069
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moved Excel to another drive rjb448 Excel Discussion (Misc queries) 2 April 2nd 06 01:13 AM
Comments in Excel minimized and moved to top of spreadsheet?!? Brian Duncan Excel Discussion (Misc queries) 0 July 6th 05 02:34 PM
Comments in Excel minimized and moved to top of spreadsheet?!? Brian Duncan Excel Discussion (Misc queries) 0 July 6th 05 02:32 PM
Comments in Excel minimized and moved to top of spreadsheet?!? Brian Duncan Excel Discussion (Misc queries) 0 July 6th 05 02:16 PM
Comments in Excel minimized and moved to top of spreadsheet?!? Brian Duncan Excel Discussion (Misc queries) 0 July 6th 05 02:08 PM


All times are GMT +1. The time now is 12:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"