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

graphics/one_icon.jpg

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.

graphics/06inf12.jpg

Edit Data by Dragging Data Markers

graphics/one_icon.jpg

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

graphics/tow_icon.jpg

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

graphics/three_icon.jpg

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.

graphics/06inf13.jpg

Insert Cells

graphics/one_icon.jpg

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.

graphics/tow_icon.jpg

Click the Insert menu, and then click Cells.

graphics/three_icon.jpg

Select the insert option you want.

graphics/foure_icon.jpg

Click OK.

graphics/06inf14.jpg

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.

    graphics/06inf15.jpg

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