Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office PowerPoint
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Add data to a chart
 
  1. In Microsoft PowerPoint, double-click the chart you want to change.
  2. Switch to the datasheet (datasheet: A table included with a chart that provides sample information showing where to type your own row and column labels and data.). 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.

advertisement