Microsoft Office Tutorials and References
In Depth Information
Making a Chart of Our Own
And charts are dynamic—meaning that any change you make in the source data will automatically
be reflected in the chart. Type a different number in any data cell contributing to the chart, and the
column, or bar, or pie slice tied to that value will experience a change in its size.
Making a Chart of Our Own
But let’s try to construct a chart of our own. In the interests of continuity, we’ll turn back to our
testgrade worksheet, which I’ve entered, sans formatting, in cells C8:I20 (if you have these data on hand
already, you can use those. And you needn’t actually calculate all those averages you see in the data,
though it would be good practice—you can just enter these as numbers here, without writing any
formulas (Figure 5-5):
Figure 5–5. That gradebook
You’ll see there are some important initial points to learn here, so let's look into them.
Excluding Data
As we indicated a few paragraphs above, you could simply click anywhere among the data and
commence the charting process in earnest. But take a look at the screen shot above. Do you want to
chart the scores of a student named Class Averages? Because you will if you don’t take steps to exclude ,
that row of data from the chart. And the same question could be asked of the column entitled Average—
do you want its data to be treated as the sixth test in the series of exam results above? Likely not; and so
in order to present Excel with precisely the data we need to in order to complete the chart, we should
select cells C9:H19 (but not the data in the I column—the test averages), as you see in Figure 5-6:
Search JabSto ::

Custom Search