Major units indicate where the gridlines are drawn across the plot area of the
graph. For example, if the major unit is set to 10, you'll have grid lines drawn
from left to right at intervals of 10 on the vertical axis. The axis labels will
be placed at the major unit intervals.
Minor units are used to indicate where more refined "tick" marks are placed on
the vertical axis. By default, minor tick marks are not displayed, but they can
be made visible from the Patterns tab of the Format Axis dialog. If the Minor
Unit is 5, you'd see one tick mark every 5 units along the vertical axis. You
can't display labels for the minor units.
You can have Excel automatically create determine the major and minor units for
a chart, based on the range of the values and the limits of the scale, or you
can use your own values.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
> What is the minor unit and the major unit? These are two properties I see
> when I try to format the axes on a graph.