Microsoft Office Tutorials and References
In Depth Information
Reformatting the Vertical Axis
Figure 6–31. Value axis options
NOTE: The fact that Major Unit field is dimmed means that the 10.0 value was automatically
selected by Excel.
2. Click the Fixed radio button by the Major Unit field.
3. Enter to replace the 10.0. 20
4. Click Close, and you should
see the chart shown in
Figure 6–32. A decent interval: Each value on the axis is now
spaced at 20 points apart.