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
Karen
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
Linking
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.
Embedding
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 - https://www.stl-training.co.uk
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
