Using the Datasheet Window
The datasheet is displayed using default data with the default chart behind it.
The top row of the datasheet holds the data to be used for the charts X-axis, or category axis
The leftmost column of the datasheet holds data to be used to label the data series of the chart i.e. the columns of a column chart.
Entering and editing data in the datasheet is simply a case of replacing the existing cell entries with the data you want to use.
Display the datasheet
If the datasheet is not visible, click the View Datasheet button on the Standard toolbar . Click this button again to hide the datasheet.
You can remove unwanted data by selecting the cells containing the data you want to remove, and pressing the Delete key.
Delete rows and columns
- Select the row(s) or column(s) you want to delete by clicking on the row or column headers
- Click Edit > Delete
Click and drag to select multiple row or column headers
Insert rows and columns
- Select the number of rows or columns you want to insert
- Click Insert > Cells
Include/exclude rows and columns
By default, all rows and columns that include data are included in the chart. When you exclude data, it appears dimmed in the datasheet and Microsoft Graph redraws the chart ignoring the excluded data.
- Double click the headings of the rows or columns you want to exclude from the chart
- Double click the headings of the excluded rows or columns to include them again