When you paste your chart into Word, make sure you select the correct Paste Options. Use one of the options that will Link Data.
Your chart will be pasted into your document.
When your Excel data has changed, make sure that you save your Excel file. Now go to the Chart Design tab in Word and click on Refresh Data.
Your chart will update to reflect the latest data.
0 Comments