123PPT provide royalty free PowerPoint templates, video backgrounds for PowerPoint, presentation photos, sound effects, PowerPoint music, and custom presentation Services.
Return to The Presenters Forum Home Page The Presenters Forum Home Page > Help With PowerPoint > PowerPoint Techniques
  New Posts New Posts
  FAQ FAQ  The Presenters Forum Search   Register Register  Login Login

Problem with Excel Charts in PowerPoint
 Post Reply Post Reply
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
jfiesmar@gmail.com View Drop Down
Newbie
Newbie


Joined: 12 Oct 2005
Online Status: Offline
Posts: 7 		  Quote jfiesmar@gmail.com Quote  Post ReplyReply Direct Link To This Post Topic: Problem with Excel Charts in PowerPoint
    Posted: 27 Oct 2005 at 09:04
Hi everyone!

I have a problem displaying my Microsoft Office Excel charts in PowerPoint. My Excel charts don't display correctly in PowerPoint.

Can anyone help?

Hula Girl
Back to Top
Charles View Drop Down
Newbie
Newbie
Avatar

Joined: 18 Sep 2005
Online Status: Offline
Posts: 28 		  Quote Charles Quote  Post ReplyReply Direct Link To This Post Posted: 27 Oct 2005 at 09:19
Hello again Hula Girl Big smile

Have you cut and paste your charts into PowerPoint or are your charts in PowerPoint created from linked Excel work sheets and documents?
Charles Henry, Creative Director 123PPT.com.
Back to Top
jfiesmar@gmail.com View Drop Down
Newbie
Newbie


Joined: 12 Oct 2005
Online Status: Offline
Posts: 7 		  Quote jfiesmar@gmail.com Quote  Post ReplyReply Direct Link To This Post Posted: 27 Oct 2005 at 09:27
They are linked to my ppt file.

Hula Girl
Back to Top
Charles View Drop Down
Newbie
Newbie
Avatar

Joined: 18 Sep 2005
Online Status: Offline
Posts: 28 		  Quote Charles Quote  Post ReplyReply Direct Link To This Post Posted: 27 Oct 2005 at 09:38
It is quite a common problem Hula,

and there are many things that can go wrong with linking Excel documents to your ppt presentation file in PowerPoint.

Do you have your chart(s) on a worksheet or on a chart sheet(s) in Excel?
Charles Henry, Creative Director 123PPT.com.
Back to Top
jfiesmar@gmail.com View Drop Down
Newbie
Newbie


Joined: 12 Oct 2005
Online Status: Offline
Posts: 7 		  Quote jfiesmar@gmail.com Quote  Post ReplyReply Direct Link To This Post Posted: 27 Oct 2005 at 09:39
Excel workseet.
 
Hula Girl
Back to Top
Charles View Drop Down
Newbie
Newbie
Avatar

Joined: 18 Sep 2005
Online Status: Offline
Posts: 28 		  Quote Charles Quote  Post ReplyReply Direct Link To This Post Posted: 27 Oct 2005 at 10:07
Ok,

I hope I can be of help Hula.

Firstly, it is always better to put the charts on their own chart sheet. Better if you create custom size chart pages in Excel so that you don't have to resize and scale the charts on your slides in PowerPoint.

The reason why it is better to create your charts on chart sheets rather than worksheets Hula is because Excel embeds the size information of the chart in the top left corner of the chart. This is often a problem with worksheets because the top left hand corner is always visible to the linking component in Microsoft Office during update links, because a chart sheet is always 100% visible.

A worksheet may not be 100% visible.

So if you had for example a chart elsewhere than the top left corner of your worksheet the update link component would look to the top left corner of the worksheet and look for the size information of the chart. but your chart is most likely not there since it is rare that people produce a chart and push it as high into the top left corner as possible so that it appears almost cut off the page.

So the following problems would arise Hula,

With the top left hand corner of the chart not appearing as visible to the link component in what would be the ActiveWindow of the spreadsheet (if it were open), the update link component will not see the chart and therefore may not update the chart.

An even worst case scenario is that PowerPoint may cut part of the chart image off the slide as it attempts to estimate the size of the chart.

There is another reason for creating your charts on chartsheets rather than worksheets Hula.

In Excel if you adjusted the View Zoom, for example from 100% to 75% at the time you created your chart. Then when you save your file and close it. PowerPoint will resize your chart to 100% when you link to it. So if your chart was too large for your screen at 100% when you created it and was the reason why you scaled it down. You will have the same problem when you link to it, only in PowerPoint the problem will be greater due to your PowerPoint template design which will also reduce the amount of screen space you have to present your chart.

The only way that you can force PowerPoint to open the Excel chart on from worksheet at the same size at which it was created and saved, is to create an Auto_Close Macro for Excel that sets the View Zoom levle back to 100% and then saves and closes the file.
Charles Henry, Creative Director 123PPT.com.
Back to Top
jfiesmar@gmail.com View Drop Down
Newbie
Newbie


Joined: 12 Oct 2005
Online Status: Offline
Posts: 7 		  Quote jfiesmar@gmail.com Quote  Post ReplyReply Direct Link To This Post Posted: 27 Oct 2005 at 10:16
Is there no way to make the chart work correctly in PowerPoint without having to make it all over again in Excel using the chart sheet?

I really don't want ot spend all those hours redoing everything Cry

Hula Girl
Back to Top
Charles View Drop Down
Newbie
Newbie
Avatar

Joined: 18 Sep 2005
Online Status: Offline
Posts: 28 		  Quote Charles Quote  Post ReplyReply Direct Link To This Post Posted: 27 Oct 2005 at 10:32
I understand that often the only way a chart makes sense Hula is on worksheet next to the chart data.

But you must create the chart on the chartsheet.

Make sure the Chart sizes with window frame option is not checked in the Options sub menu from the Tool main menu option.

You can always copy your chart back from your chart sheet to your worksheet, by simply selecting the entire chart on the chart sheet and copying and pasting it to the worksheet near the data range.

Don't cut and paste Hula. Use Copy as it is important that the original chart on the chart sheet remains intact as this is the chart that PowerPoint will link to not your copied version on the worksheet.

Any changes made to your data will reflect on the chart sheet chart, and since the worksheet chart is linked to the chart sheet chart, that will also instantly update Smile

Now use the chart from the chart sheet to copy and paste link onto your slide in PowerPoint, and voila you have your chart correctly formated and uptodate Smile
Charles Henry, Creative Director 123PPT.com.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down


123PPT.com is a part of 123OfficeMedia.
All content within this page remains the property of 123PPT.com
and may not be reproduced, copied or otherwise republished without written consent.

© 2008 123PPT.com. All rights reserved.

123NetProtect is a security and data protections standard which provides online shoppers with peace of mind and security whilst shopping on 123NetProtect certified sites.