Use charts and graphs in your presentation
Office PowerPoint 2007 includes many different types of data charts and graphs including column charts, line graphs, pie charts, bar charts, area graphs, scatter graphs, stock charts, surface charts, doughnut charts, bubble graphs, and radar graphs.
If Office Excel 2007is not installed, when you create a new data chart in Microsoft Office PowerPoint 2007, Microsoft Graph opens. A chart then appears with its associated data in a table called a datasheet. You can enter your own data in the datasheet, import data from a text file to the datasheet, or paste data from another program to the datasheet.
In this article
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.
Insert a chart or graph in your presentation
Do the following when you want to create a new chart or graph in PowerPoint:
In PowerPoint, click the placeholder that you want to contain the chart.
On the Insert tab, in the Illustrations group, click Chart.
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 on an Excel worksheet
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.
When you are finished inputting the data in Excel, on the File menu, click Close.
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 Excel data or charts to PowerPoint.
In Excel, select the chart by clicking its border, and then on the Home tab, in the Clipboard group, click Cut.
In PowerPoint, click the placeholder on the slide or notes page that you want to insert the chart on.
On the Home tab, in the Clipboard group, click the arrow under Paste, and then click Paste.
Create an organization chart, a timeline, or add a chart from Excel
To create an organization chart, see the article Create an organization chart.
To create a timeline using a SmartArt graphic, see the article Create a SmartArt graphic.
To learn about the different types of Excel charts that you can add to your PowerPoint slides, see the article Available chart types.