pasting chart excel

Forum home » Delegate support and help forum » Microsoft Powerpoint Training and help » Pasting a chart from Excel 2013 into PowerPoint 2007 or 2013

Pasting a chart from Excel 2013 into PowerPoint 2007 or 2013

resolvedResolved · Urgent Priority · Version 2013

Karen has attended:
Excel Pivot Tables course

Pasting a chart from Excel 2013 into PowerPoint 2007 or 2013

Good afternoon, when we paste in a chart from Excel, most of the chart appears in PowerPoint apart from the legend name which appears as #REF! This is probably because it is trying to link to the original data in the spreadsheet but the rest of the data appears in the chart in PowerPoint...
Thank you

You may also wish to consider our presentation skills course London.

RE: pasting a chart from Excel 2013 into PowerPoint 2007 or 2013

Hi Karen,

I've seen this a few times before. Sometimes re-making the chart in Excel and pasting it fixes the #Ref.

Options to explore - how it is being pasted

There are two ways of copying a live chart
When you right click you get a choice of Paste Special, you will see these options if you hover over the icons

Leaves the Chart in Excel and links all of the data points to the Excel data. Likely to get the #REF error.
If you have a password on the Excel file/protection then this can cause a #REF error.

Copies the Excel file and brings it into PowerPoint and draws the chart from that one.
This is an internal link. Less likely to get a #REF.

When you click on the Chart - look for the Green tab along the top, Chart Design and click on Update. Try doing this with the Excel file open, if that fixes it, then it's a security/file location issue.

Please send me a further message if trying that doesn't fix the problem.

Kind regards

Richard Bailey
Microsoft Certified Trainer

Best STL -
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 18 Nov 2016: Automatically marked as resolved.


Training courses


Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


PowerPoint tip:

Black out the screen

black out the screen: press the letter b

View all PowerPoint hints and tips

Server loaded in 0.12 secs.