I have a Microsoft Word 2016 document containing editable charts created in an Microsoft Excel 2016 spreadsheet on a Windows 7 PC. Both of these files were created by a contact in another organisation. I do not have the Excel spreadsheet.
I need to copy the charts from the Word document, however, my system freezes when I try this. I'm unable to copy and paste the chart.
I believe the charts contain a large amount of data. I assume that the best approach would be to copy the chart again from the Excel spreadsheet and paste as a picture into the Word document, but I don't have access to the spreadsheet. Is there another way that I can get around this problem?
It's a recurring problem involving multiple correspondents sending us Word documents containing Excel charts with editable data. We would need to educate them by either asking them to paste charts as a picture or to send us the Excel spreadsheet. But we also need a workaround so that we can resolve this issue independently.
Answer
There is a much easier way to do this. Use the snipping tool to make a png of the chart that you want and insert it as an image in your word document.
5 Ways to Open Snipping Tool in Windows 10
How to Insert a Picture in Your Text in Word 2016
No comments:
Post a Comment