Share via

Refresh Data in Word Chart from Excel

Anonymous
2016-10-12T17:11:13+00:00

Hello,

I've created a number of charts in Excel.  In order to distribute them in a more aesthetically-pleasing manner, I've copied and pasted them into a Word document.  The excel data is updated every month, and I want the copied charts in the Word document to reflect those updates.

When I click on "Refresh Data" in the Chart Tools Design tab in the Word document, all data in the chart (i.e., bars) is removed...leaving an empty chart.

How do I get the copied charts in my Word document to correctly reflect/update the changes I've made in the linked Excel document?

I've gone back and tried using the "Paste Special" option (paste link to be exact) when pasting the copied charts into the Word document, but that hasn't fixed the issue.

Any help would be much appreciated.

Thanks,

Mark

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-10-13T14:58:38+00:00

    Hi Mark,

    For us to assist you with your Excel concern, here is the link for all the basics about Excel: https://support.office.com/en-us/excel.

    For a more advanced suggestions and troubleshooting with Excel, please check out our advanced website called Technet. Get in touch with them by clicking the link below:

    https://technet.microsoft.com/en-us/.

    Let us know how it goes.

    Regards.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments