Insert a linked Excel chart in PowerPoint

 

You can insert and link a chart from an Excel workbook into your PowerPoint presentation. When you edit the data in the spreadsheet, the chart on the PowerPoint slide can be easily updated.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.
44 seconds

Insert a linked chart

  1. Open the Excel workbook that has the chart that you want. Save the workbook.

  2. Select the chart.

  3. On the Home tab, in the Clipboard group, click Copy  The Copy button .

  4. Open the PowerPoint presentation that you want and select the slide that you want to insert the chart into.

  5. On the Home tab, in the Clipboard group, click the arrow below Paste, and then do one of the following:

    • If you want the chart to keep its look and appearance from the Excel file, select Keep Source Formatting & Link Data  The Keep Source Formating and Link Data button .

    • If you want the chart to use the look and appearance of the PowerPoint presentation, select Use Destination Theme & Link Data  The Use Destination Theme and Link Data button .

Caution: If you were to subsequently move the Excel file to another folder, that would break the link between the chart in the PowerPoint presentation and the data in the Excel workbook.

Update the data that's appearing in the chart

When the underlying Excel data has been changed in the workbook, you can make those changes be reflected in the chart that's appearing in your presentation:

  1. Select the chart.

  2. On the Chart Tools Design tab of the toolbar ribbon, in the Data group, select Refresh Data.

    The Design tab under Chart Tools.

For information about how to edit chart data, see Change the data in an existing chart.

Related

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

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.

×