Microsoft Office Tutorials and References
In Depth Information
Adding and editing axis titles
Be aware that major gridlines in certain kinds of three-dimensional charts can make data
points appear to have less than their true value. In the following illustration, for example,
the data points have exact integer values from 1 to 10, but the gridlines, in combination
with the three-dimensional perspective, make each point appear somewhat smaller.
Adding and editing axis titles
To add axis titles to a chart, select the chart, click the Chart Elements button, and select the
Axis Titles check box. To add or delete a title for a particular axis only, click the arrow to
the right of the Axis Titles check box and then clear or select the check box for the axis in
Excel initially uses default text for axis titles. You can edit that text in the same manner that
you edit chart title text; for details, see “Adding, editing, and removing a chart title” earlier
in this chapter.
Working with axes
To display or suppress one or more chart axes, select the chart and click the Chart Elements
button. You can make all the axes disappear or reappear by clearing or selecting the Axes
check box. To manipulate a particular axis, click the arrow to the right of Axes in the Chart
Elements list.
If you’re an Excel veteran, you might have seen the terms category axis and value axis in
some older versions of the product. Excel now uses the more commonplace descriptions
horizontal and vertical . It’s worthwhile understanding why the older terms were used,
however. A value axis is one that is scaled numerically. Value axes are generally vertical (except
in bar charts, which are essentially column charts rotated 90 degrees), but in an X Y (scat-
ter) chart, both the vertical and horizontal axes are value axes. A category axis is delineated
either by labels that have no numeric significance or by dates.
Search JabSto ::

Custom Search