• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Entering Data

You enter your chart data in the datasheet window (Figure 4.7). The datasheet initially appears with sample data. Be sure to erase it before entering your own data.

Figure 4.7. The sample data automatically fills the datasheet.


To enter data in the datasheet:

1.
If you haven't already done so, double-click the chart placeholder to launch Microsoft Graph.

2.
If you don't see the datasheet window, click the View Datasheet button.

3.
To erase the sample data, click the Select All button (Figure 4.7) and press Delete (Windows) or Del (Mac OS).

4.
Enter your chart data (Figure 4.8).

5.
To view the chart, move the datasheet aside (by dragging the window's title bar) or close the datasheet window (by clicking the View Datasheet button).

Figure 4.8. Enter chart data in the datasheet.


Tip

Be sure to use the Select All button when deleting the sample data. If you just delete a range of cells and your data consumes fewer rows and columns than the sample data, Microsoft Graph still reserves space for this data on the chart (Figure 4.9). To fix this problem, use the Exclude Row/Col command on the Data menu. This command tells Graph not to chart the data in the selected row or column.

Figure 4.9. The Exclude Row/Col command on the Data menu will fix the problems on this chart.



Tip

Alternatively, you can enter legend labels in the top row and x-axis labels in the first column of the datasheet. But you must use the Data > Series in Columns command to let Graph know that the data series are entered into columns instead of rows.


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint