I want to edit the data of a chart that is linked to an Excel® table

Editing Excel® table in the linked file:

First, open the PowerPoint® presentation including the table which you wish to edit. Click on the chart, and an action bar will automatically appear above the selected chart. Now choose the action point Data and then Open link source. The linked Excel® table will be opened and you can make your desired changes as required.

 

Once you have saved the changes to your Excel® file, your empower chart will receive an update notification.

 

It is also possible to update a chart without having the presentation opened, simply by changing the connected Excel® file. Open the Excel® file that is linked to the chart you wish to edit. Make the desired changes within the Excel® table and click on „Save“. Now open the presentation that includes the linked chart.

If the option „Refresh data on open“ is activated, the chart is updated automatically once the presentation is opened. If this option is deactivated, a manual update is possible by clicking on the action point Refresh in the action bar above the selected chart.

 

If you do not wish to change the original Excel®, but still need to change the data displayed in the chart, you can do so by breaking the link to the Excel® file. In Data click on Break Link.

Once you have confirmed the break, the chart will be connected to a table that works indepentenly from the original Excel® file. You can now change its data by clicking on Data in the action menu and then clicking Edit Data. An Excel® window will open in which you can edit the chart data, however the original Excel® file will no longer be affected. If you wish to re-establish the Excel® link, please click Data and Excel Link to re-link the Excel® file.

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.