Microsoft Office Tutorials and References
In Depth Information
Providing the Raw Data for Your Chart
a chart in
in the data
As you enter numbers and labels in the data grid, watch your chart take
shape. Here are the basics of entering data in the data grid:
✦ Entering the data in a cell: A cell is the box in a data grid where a
column and row intersect; each cell can contain one data item. To enter
data in a cell, click the cell and start typing. When you’re finished, press
Enter, press Tab, or click a different cell.
✦ Deleting the data in a cell: To delete the data in a cell, including the
sample data, click the cell and press Delete.
✦ Displaying the numbers: When a number is too large to fit in a cell, the
number is displayed in scientific notation. Don’t worry — the number is
still recorded and is used to generate your chart. You can display large
numbers by widening the columns in which the numbers are found.
Move the pointer between column letters (A, B, and so on at the top of
the worksheet) and when you see the double-headed arrow, click and
drag to the right.
✦ Changing the size of the data range: To enclose more or fewer cells in
the data range, move the pointer to the lower-right corner of the data
range, and when the pointer changes into a two-headed arrow, click and
drag so that the blue box encloses only the data you want for your chart.