Microsoft Office Tutorials and References
In Depth Information
Labeling an axis with non-equal intervals
4. Select the new line series and choose Chart
Chart Type. Specify an XY
(Scatter) chart using the subtype that displays lines and markers. The XY
series will appear on top of the chart’s value axis. The X value axis for the
new series appears on the top, and its Y value axis appears on the right.
5. Select the XY series and access the Format Data Series dialog box. In the
Patterns tab, make the line color black and specify a tick as the marker
style. In the Data Labels tab, specify any option (the labels will be
changed later).
6. Select the data labels for the XY series and access the Format Data Labels
dialog box. In the Alignment tab, specify Left for the Label Position. You
will need to adjust the size and position of the Plot Area to accommodate
the left-positioned labels.
7. Now it’s time to clean up the axes. Select the real value axis on the left
(this is the axis for the line series). Access the Format Axis dialog box,
select the Scale tab, and set Minimum to 0, the Maximum to 100, and the
Major Unit to 20. These selections create gridlines that divide the chart
into five vertical sections to correspond to the five letter grades. Then
select the Patterns tab and set all options to None (to hide the axis).
8. Select the X value axis for the XY series (it will be at the top of the chart)
and access the Format Axis dialog box. In the Patterns tab, set all options
to None. Doing so hides the axis.
9. Select the Y value axis for the XY series (it will on the right side of the
chart). Access the Format Axis dialog box. In the Scale tab, set the
Minimum to 0, the Maximum to 100, and the Major Unit to 20. In the
Patterns tab, set all options to None.
10. Finally, select each individual data label for the XY series and change the
text to correspond to the letter grade labels in column C.
To apply the data labels automatically, refer to the sidebar “Applying
Custom Data Labels,” in this chapter.
Labeling an axis with non-equal intervals
In the previous example, the dummy axis had equal-intervals: Each y value was
separated by 20. Figure 8-14 shows another chart that uses a dummy value axis, but this
time the scale intervals on the value axis vary in size. Essentially, this chart makes it
easy to translate the monthly numeric rating values into descriptive text. As you can
see from the chart, June is the only month in which a “Good” rating was attained.
Search JabSto ::




Custom Search