Editing Graph Data

Although most of the time you edit Microsoft Graph data in the datasheet, you can also change data in the chart by dragging a data marker. You can edit data one cell at a time, or you can manipulate blocks of adjacent data called ranges . If you are familiar with worksheets, such as Microsoft Excel, you will find that Microsoft Graph uses many of the same data editing techniques.

Edit Cell Contents


In the datasheet, click the cell you want to edit.

  • To replace the cell contents, type the new data into the cell. It replaces the previous entry.

  • To edit the cell content, double-click the selected cell where you want to edit.

    Press Delete or Backspace to delete one character at a time, and then type the new data.


Edit Data by Dragging Data Markers


In the chart, click the data series that contains the data marker you want to change.


Click the data marker. When you select a data marker, a box appears that identifies the series and the value.


Drag the data marker for line or scatter plots, the top-center selection handle for bar or column charts , and the largest selection handle on the edge of a pie chart.


Insert Cells


In the datasheet, click where you want to insert cells.

  • To insert a column, click the column heading to the right of where you want the new column.

  • To insert a row, click the row heading below where you want the new row.

  • To insert a single cell, click an adjacent cell.


Click the Insert menu, and then click Cells.


Select the insert option you want.


Click OK.


Delete Data from a Datasheet or a Graph

  • Select the cell or range in the datasheet that contains the data you want to delete, and then press Delete.

  • Click the data series in the graph, and then press Delete.


Did You Know?

You can exclude or include row or column data . Instead of deleting data, you can exclude row or column data from a graph and then include it later. Select the row or column you want toe exclude or include, click the Data menu, and then click Exclude Row/Col or Include Row/Col.

Show Me Microsoft Office PowerPoint 2003
Show Me Microsoft Office PowerPoint 2003 (Show Me Series)
ISBN: 078973009X
EAN: 2147483647
Year: 2002
Pages: 271

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net