Chapter 21: Using Advanced Charting Techniques
21
To adjust the tick marks displayed on an axis, click the Tick Marks section of the Format
Axis dialog box to expand that section. The Major and Minor Tick Mark options control the
way the tick marks are displayed. Major tick marks are the axis tick marks that normally
have labels next to them. Minor tick marks fall between the major tick marks.
If you expand the Labels section, you can position the axis labels at three distinct loca-
tions: Next to Axis, High, and Low.
Refer to Figure 21.14. When you combine these settings with the Axis Crosses At option,
you have a great deal of flexibility.
FIGURE 21.14
Excel offers a great deal of flexibility in how you can display axis labels and crossing points.
The last section of the task pane, Number, lets you specify the number formatting for the
value axis. Normally, the number formatting is linked to the source data, but you can over-
ride that.