Microsoft Office Tutorials and References
In Depth Information
Evaluating the Chart
Note the array of column chart sub-types. For illustration’s sake, I’ll click the first option on the first
row (titled 2-D Column ), yielding this chart (Figure 5-8):
Figure 5–8. Not bad—a first column chart
There’s your chart. Suitable for framing? Probably not, but it does communicate the data pretty
clearly, even if a formatting tweak here and there would help it along. And if you need or want to, you
can delete a chart by clicking on its chart area to select the entire chart, and pressing Delete.
Evaluating the Chart
But before we tweak, let’s review some of the things the chart has done with the data. The chart portrays
each student’s scores for tests 1 through 5, with each test number comprising a data series. The legend—
that column of numbered cubes on the chart’s far right—color-codes each exam series, while the vertical
(value) axis (also known as the Y axis ) constructs the scale of values against which each test can be
measured. That scale—here spanning 0 to 120 and subdivided into intervals of 20—is improvised from the
data. Devise a new chart based on a different set of values and the scale could look radically different. The
Horizontal (Category) Axis (also called the X axis ) enumerates each student name, placing these beneath
each set of their five scores. It requires a bit of delicacy in view of the thinness of the columns, but if you
position your mouse atop any column in the chart (don’t click) a caption detailing the value of that score
along with the name of the student in question appears (Figure 5-9):
Search JabSto ::

Custom Search