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 2013 Cell Basics lesson.

To insert a chart:

  1. Select the Insert tab, then click the Chart command in the Illustrations group.
    Screenshot of PowerPoint 2013Clicking the Chart command
  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.
    Screenshot of PowerPoint 2013Choosing a chart type
  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.


    Screenshot of PowerPoint 2013The placeholder source data and the corresponding chart
  5. Enter data into the worksheet.


    Screenshot of PowerPoint 2013Entering data into the worksheet
  6. If necessary, click and drag the lower-right corner of the blue line to increase or decrease the data range for rows and columns. Only the data enclosed by the blue lines will appear in the chart.


    Screenshot of PowerPoint 2013Dragging the blue line to decrease the data range
  7. When you're done, click the X to close the spreadsheet.


    Screenshot of PowerPoint 2013Closing the worksheet
  8. The chart will be completed.


    Screenshot of PowerPoint 2013The completed chart

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

Screenshot of PowerPoint 2013Clicking the Edit Data command

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

Screenshot of PowerPoint 2013Insering a chart from a placeholder

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.