Embedding an Excel Chart (Excel 2010) into a Powerpoint (2010) presentation

Question

I am using Office 2010 and when I try to embed an Excel Chart into Powerpoint, I get different errors.  If I copy the Excel Chart and then go into Powerpoint and do a Paste Special, Paste Link and click Microsoft Excel Chart Object, I get a copy of the chart including the title and text box I have assocated with the chart in Powerpoint and I am able to update the chart in excel and the changes will be displayed in Powerpoint (including updates to the text box and title), however, the right side of the chart is truncated.   If I copy the Excel Chart and then go into PowerPoint and do a Paste Use Destination theme and Link Data, I get the chart with the title and a text box, however, when I update the chart in excel only the data of the chart is updated not the title or the text box.  I need to be able to link the data from excel to PowerPoint and I need it to update the title and the text boxes in the chart in Powerpoint.  Does anyone have any recommendations for getting the chart not to truncate on the right side? 

Thanks,

kcsmiles

Answer 1

Hi KC Smiles,

I will help you with the issue.

In order to better assist you, I need more information:

Does this issue occur with a particular type of Chart or all types of Chart embedded to PowerPoint.

Use a different type of chart and check if the issue occurs.

You may disable the Hardware Graphics Acceleration for PowerPoint following the steps below and check if the issue occurs:

• Click the File tab.
• Click Options.
• Click Advanced.
• Under Display, select the Disable hardware graphics acceleration check box.

Let us know the details and results for further assistance.

Thank you.

Answer 2

Aravinda Balakrishna,

Thank you for your reply.  I am creating the chart in an Excel Macro in 2010.  The chart I originally created was a line with markers.  I changed it to just a line and still got the same results.  What is happening is that when I create the chart in Excel, everything looks fine.  I go to PowerPoint and I copy and paste it in as Paste Special, Paste Link, Microsoft Excel Chart Object and it looks great, even after I resize it within the presentation.  I can save the file and open it up and as long as I don't update the links everything looks good.  But as soon as I update the links so that it pulls the updated data from the Chart in Excel it truncates the right side.  I followed the steps that you had to disable the Hardware Graphics Acceleration for PowerPoint and it made not difference, I still got the same results.  I tried changing the Chart in Excel to a bar chart and did the same steps to paste it into PowerPoint and it still truncated the right side.  It wasn't as noticeable because the text box was moved more over away from the right side of the chart, but it is truncating the right side of the legend.  The legend is at the bottom of the chart and expands almost the entire length of the chart.  There are 13 datapoints which are dates, so they are displayed in the legend and it is cutting off most of the year in the last datapoint.

Do you have any other ideas or suggestions?  Again, it is only happening after I update the links, not in the initial paste or even if I save and close out of Powerpoint and reopen it as long as I don't update the links it looks fine.  However, I want to updated the links because want the presentation updated every time the excel chart gets updated.

Thank you,

kcsmiles

Answer 3

Hi KC Smiles,

Thank you for the reply and sorry for the delay in response.

It would be nice if you provide us a screenshot after the links are updated to better assist you.

Let us know the details to help you better.

Thank you.

Answer 4

Aravinda,

I tried doing a screen shot before and pasting it in, but that didn't work.  This time I saved the screen shots as pictures.

This is a screen shot of what the chart looks like in PowerPoint immediately after I copied it in from Excel.  I just selected the chart in Excel did a copy, then when into PowerPoint, did a Paste Special, choose Paste Link, then choose Microsoft Excel Chart Object.

I then saved the PowerPoint presentation and opened it up again.  When it asked to update links, I selected Cancel, so it just opened the presentation without updating the links.  Again, it looks fine.

Then I closed the Powerpoint presentation again.  Opened the Powerpoint presentation and selected Update Links.  Once I do that, it reformats the charts and cuts off the right side and the bottom of the chart.  Like I said, I need the ability to update the links.

There are other options that I can choose, that don't truncate the chart like this, for example, if under the paste options, I paste the chart in as Use Destination Theme and Link Data, then the chart comes in fine and when the link is updated the format of the chart still looks fine, however, with that option the title and the text box are not updated, so the actually data in the legend is updated, but not the other information on the chart (title & text box).  I can copy those in seperately, but then I am copying and linking three seperate items (chart itself, text box, and title) for each chart in Excel.  That seems to be a lot of extra work.  It seems like I should just be able to do the paste link, that I have above without it truncating the chart when the link is updated.

Any help you can provide would be greatly appreciated.

Thanks,

kcsmiles

Answer 5

Does anyone have any suggestions or ideas about what could be causing this and how I can prevent it from truncating the chart?  Any help would be greatly apprecated!  We have many users who are importing charts from excel into powerpoint and it would save a great deal of time if would could get it to work correctly. 

Thanks,

kcsmiles