Use charts and graphs in your presentation

You can include many different types of data charts and graphs in your PowerPoint presentation. These include column charts, line graphs, pie charts, bar charts, area graphs, scatter graphs, stock charts, surface charts, doughnut charts, bubble graphs, and radar graphs.

Notes: 

  • Don't see the chart that you want in this article?  For more information about the variety of graphs and charts you can use, see Available chart types.

  • If Microsoft Excel isn't installed on your computer, you will not be able to take advantage of the advanced data charting capabilities in Microsoft Office. Instead, when you create a new data chart in PowerPoint, Microsoft Graph opens.

You can make a chart in PowerPoint or Excel. If you have lots of data to chart, create your chart in Excel, and then copy it into your presentation. This is also the best way if your data changes regularly and you want your chart to always reflect the latest numbers. In that case, when you copy the chart, keep it linked to the original Excel file.

Create a chart in PowerPoint

To create a simple chart from scratch in PowerPoint, click Insert > Chart and pick the chart you want.

  1. Click Insert > Chart.

    shows the insert chart button in powerpoint
  2. Click the chart type and then double-click the chart you want.

    Shows column chart selection in powerpoint

    Tip: For help deciding which chart is best for your data, see Available chart types.

  3. In the spreadsheet that appears, replace the default data with your own information.

    Spreadsheet showing default data for chart
  4. When you’ve finished, close the spreadsheet.

Tip: When you insert a chart, small buttons appear next to its upper-right corner. Use the Chart Elements Chart Elements button button to show, hide, or format things like axis titles or data labels. Or use the Chart Styles Customize the Look of Your Chart button button to quickly change the color or style of the chart. The Chart Filters Chart Filters button button is a more advanced option that shows or hides data in your chart.

Top of page

You can use Microsoft PowerPoint 2010 to make and edit charts and graphs using data in Microsoft Excel 2010. There are two ways to add a chart or graph to a presentation:

  • You can create a chart or graph in your presentation.    When you create a chart in PowerPoint, the data for that chart is edited using Microsoft Excel 2010, but the data is saved with the PowerPoint file.

  • You can paste an Excel chart or graph into your presentation and link to the data in an Excel file.    When you copy a chart from a saved Excel file and paste it into your presentation, the data in the chart is linked to that Excel file. If you want to change the data in the chart, you must make your changes to the linked worksheet in Excel, and then refresh the data in your PowerPoint presentation. The Excel worksheet is a separate file and is not saved with the PowerPoint file.
    Pasting a linked chart or graph is the easiest way to incorporate a chart built from an existing Excel workbook, or one with a large amount of data. For more information, see Insert a linked Excel chart in PowerPoint 2010.

Create a chart or graph in a presentation

  1. On the Insert tab, in the Illustrations group, click Chart.
    The Illustrations group on the Insert tab

  2. In the Insert Chart dialog box, click the arrows to scroll through the chart types.

    Select the type of chart that you want and then click OK.

    You can choose from many different types of graphs in the Insert Chart dialog box

    Tip: When you rest the mouse pointer over any chart type, a ScreenTip displays its name.

  3. Edit the data in Excel 2010.

    Sample data for a chart

    When you are finished editing your data, you can close Excel.

  4. Click the File tab and then click Close. The chart in PowerPoint is automatically updated with the new data.

You can modify the chart in PowerPoint, including changes to appearance, size or position. Click the chart, then on the green Chart Tools tab, use the Design, Layout or Format tab to make changes. To add animation effects to the chart, use tools on the Animations tab.

The Chart Tools tab appears when you click a chart.

Note: If you don't see the Chart Tools, make sure that you click anywhere inside the chart to activate it.

You can change chart data in PowerPoint. Click the chart, then on the green Chart Tools tab, select the Design tab, and then click Edit Data. For more details, see Change the data in an existing chart.

Top of page

Tips

  • To get a good idea of what you can add to or change in your chart, under Chart Tools, click the Design, Layout, and Format tabs, and then explore the groups and options that are provided on each tab.

    The Chart Tools contextual tab will only appear if you have selected your chart.

  • You can also access design, layout, and formatting features that are available for specific chart elements (such as chart axes or the legend) by right-clicking those chart elements.

  • Some types of charts, such as organization charts, flow charts, hierarchical diagrams, or showing repetitive information, might be more easily and effectively created using SmartArt. If you are not sure which would be the best tool, see When should I use a SmartArt graphic and when should I use a chart?

More information

Top of page

In this article

Overview of data charting and graphing

Insert a chart or graph in your presentation

Paste an Excel chart or graph into your presentation and link to data in Excel

Create another type of chart (flow chart, organization chart, timeline)

Overview of data charting and graphing

You can add a data chart or graph to your presentation in one of two ways:

  • You can create a chart or graph in your presentation.    When you create a new chart in PowerPoint, you edit the data for that chart in Office Excel 2007, but the data is saved with the PowerPoint file.

  • You can paste an Excel chart or graph into your presentation and link to the data in an Office Excel 2007 file.    When you copy a chart from a saved Office Excel 2007 file and paste it into your presentation, the data in the chart is linked to that Excel file. If you want to change the data in the chart, you must make your changes to the linked worksheet in Office Excel 2007 and then refresh the data in your PowerPoint presentation. The Excel worksheet is a separate file and is not saved with the PowerPoint file.

Note: If you open a presentation that was created in an earlier version of PowerPoint and the presentation contains a graph or chart that was created by using Microsoft Graph, PowerPoint 2007 will maintain the look and feel of the graph or chart, and let you continue to update your graph or chart.

Chart from sample data
A chart in PowerPoint that is made up of sample data from an Excel worksheet

Insert a chart or graph in your presentation

  1. In PowerPoint, click the placeholder that you want to contain the chart.

  2. On the Insert tab, in the Illustrations group, click Chart.

  3. In the Insert Chart dialog box, click a chart, and then click OK.

    Office Excel 2007 opens in a split window and displays sample data on a worksheet.

    Sample data for a chart
    Sample data on an Excel worksheet
  4. In Excel, to replace the sample data, click a cell on the worksheet, and then type the data that you want.

    You can also replace the sample axis labels in Column A and the legend entry name in Row 1.

    Note: After you update the worksheet, the chart in PowerPoint updates automatically with the new data.

  5. When you are finished inputting the data in Excel, on the File menu, click Close.

Note: To change the data in a chart you've inserted,     use the Edit Data command. To learn more about the Edit Data command, see Change the data in an existing chart.

Paste an Excel chart or graph into your presentation and link to data in Excel

You create and copy the chart or graph in Office Excel 2007 and then paste it into your PowerPoint presentation. When you update the data in the linked Office Excel 2007 file, you can update the chart in PowerPoint by using the Refresh Data command.

To learn more about copying and pasting Excel charts and graphs into your PowerPoint presentation, see the article Copy an Excel chart to another Office program.

Note: If you want to be able to automatically update or refresh the data in your chart or graph, you must save the Excel file before inserting the chart or graph.

  1. In Excel, select the chart by clicking its border, and then on the Home tab, in the Clipboard group, click Cut.

  2. In PowerPoint, click the placeholder on the slide or notes page that you want to insert the chart on.

  3. On the Home tab, in the Clipboard group, click the arrow under Paste, and then click Paste.

Top of page

Create an organization chart, a timeline, or add a chart from Excel

Tip: If you don't know whether you need a data chart or some other type of graphic, see the article When should I use a SmartArt graphic and when should I use a chart?

Top of page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×