Change the data in an existing chart

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

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.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×