Change the data in an existing chart

If you create a chart for your presentation and then the data used in the chart changes, you can update the data so that the chart is accurate.

  1. Select the chart that you want to change.

  2. Under Chart Tools, on the Design tab, in the Data group, click Show Data.

    Microsoft Office Excel opens in a split window and displays the worksheet that you want to edit.

  3. To edit the contents of a title or data in a cell, in the Excel worksheet, click the cell that contains the title or the data that you want to change, and then type the new information.

  4. Do one of the following:

    • If the chart is linked, save the worksheet.

    • If the chart is embedded, go to step 5. PowerPoint saves the embedded charts automatically.

      Note: To help you determine if a chart is linked or embedded, see Use charts in your presentation.

  5. In Excel, on the Microsoft Office Button, click Close.

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!