Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / February 2007

Tip: Looking for answers? Try searching our database.

Graphs in Excel Moved to PP

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
K. E. McClure - 28 Feb 2007 00:30 GMT
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
Echo S - 28 Feb 2007 00:37 GMT
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.

Signature

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/

> 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
[quoted text clipped - 16 lines]
>
> Kenny
john - 28 Feb 2007 09:43 GMT
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.
Signature

John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

> 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
[quoted text clipped - 15 lines]
>
> Kenny
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.