Importing Microsoft Excel Data

1. On the Insert menu, click Chart.

2. Switch to the datasheet. If the datasheet is not visible, click View Datasheet to display it.

3. To start the imported data at a cell other than the upper-left cell on the datasheet, select the cell you want.

4. Click Edit > Import File.

Note: Datasheet: A table included with a chart that provides sample information showing where to type your own row and column labels and data.

5. In the Look in box, click the drive, folder, or Internet location that contains the file, and click the *.xls file format in the Files of type box.

6. Double-click the file you want to import.

7. In the Import Data Options dialog box, browse the sheet that you want to import. Remember, you can import only one sheet. So do one of the following:

1. To import all the data on the worksheet, click Entire sheet under Import.
2. To import part of the data, click Range, and then type the range of data you want. For example, to import cells A1 through B5, type A1:B5 in the Range box. If the range is named, you can type the name instead of the range reference.
3. If you selected a cell in step 3, clear the Overwrite existing cells check box.

To edit data for a chart created in Microsoft Excel:

1. In the PowerPoint work space, double-click the chart in which you want to edit data. The menus and toolbars now change to show the Microsoft Excel menus and buttons.
2. Click the tab for the sheet that contains the data for the chart—for example, Sheet1.
3. Type the new data in the cells on the worksheet.
4. To make sure that the chart is displayed in the PowerPoint presentation when you return to the slide, click the tab for the sheet that contains the chart—for example, Chart1.
5. To return to the slide, click outside the chart.

Tip: Microsoft PowerPoint comes with slide layouts that include placeholders for charts. To create a new slide by using one of these layouts, click New Slide on the Insert menu, and then select one of the layouts that contain a chart placeholder.