Charts

PowerPoint charts let you communicate data graphically. Use charts in PowerPoint to help see the meaning behind the numbers.

Inserting charts

PowerPoint uses a spreadsheet as a placeholder for entering chart data, much like Excel. The process of entering data is fairly simple, but if you are unfamiliar with Excel you might want to review our Excel 2016 Cell Basics lesson.

To insert a chart:

  1. Select the Insert tab, then click the Chart command in the Illustrations group.
  2. A dialog box will appear. Select a category from the left pane, and review the charts that appear in the right pane.
  3. Select the desired chart, then click OK.
  4. A chart and a spreadsheet will appear. The data that appears in the spreadsheet is placeholder source data you will replace with your own information. The source data is used to create the chart.
  5. Enter data into the worksheet.
  6. Only the data enclosed by the blue lines will appear in the chart, but this area will expand automatically as you continue to type.
  7. When you're done, click X to close the spreadsheet.
  8. The chart will be completed.

You can edit the chart data at any time by selecting your chart and clicking the Edit Data command on the Design tab.

You can also click the Insert Chart command in a placeholder to insert a new chart.

Creating charts with existing Excel data

If you already have data in an existing Excel file you want to use for a chart, you can transfer the data by copying and pasting it. Just open the spreadsheet in Excel, select and copy the desired data, and paste it into the source data area for your chart.

You can also embed an existing Excel chart into your PowerPoint presentation. This may be useful when you know you'll need to update the data in your Excel file and want the chart to automatically update whenever the Excel data is changed.

Read our guide on Embedding an Excel Chart for more information.