Add data to a chart

Microsoft Office PowerPoint 2003

  1. In Microsoft PowerPoint, double-click the chart you want to change.
  2. Switch to the datasheet. If the datasheet is not visible, click View Datasheet Button image to display it.
  3. Do one of the following:

    ShowEnter data

    1. Click a cell, and then type the text or numbers you want.

      For information about working on the datasheet, click Microsoft Graph Help on the Help menu.

    2. To return to the slide, click outside the chart.

    Note  The first row and column of the datasheet are reserved for text that identifies the information in that row or column. In the case of an xy (scatter) or bubble chart, the first row or column contains values.

    ShowImport data

    1. If you want the imported data to begin at a cell other than the upper-left cell on the datasheet, select the cell you want.
    2. On the Edit menu, click Import File.
    3. Double-click the file you want to import.
    4. Do one of the following:

      ShowImport a text file

      • Follow the instructions in the Text Import Wizard dialog boxes.

      ShowImport a Microsoft Excel spreadsheet or chart

      1. In the Import Data Options dialog box, select the sheet you want to import. You can import only one sheet.
      2. Do one of the following:

        • To import all the data on the worksheet, click Entire sheet under Import.

        • 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 earlier in the procedure, clear the Overwrite existing cells check box.

    ShowLink to data

    When you link to data in another program, such as a Microsoft Word table or Microsoft Excel spreadsheet, all existing data from the Microsoft Graph datasheet is deleted.

    1. In the source program, select the data you want to link to the datasheet of the PowerPoint chart. For example, if you are working in an Excel worksheet, select a range of cells.
    2. On the program's Edit menu, click Copy.
    3. In PowerPoint, switch to the datasheet of the chart.
    4. On the Edit menu, click Paste Link.

    Note  The chart will be updated when the data in the source program changes.