Body
Question
How do I change the axis scale in Excel?
Answer
There are four values that comprise the y-axis scale: the minimum, maximum, major unit, and minor unit.
- The minimum and maximum values are the smallest and largest tick marks that will appear on the axis.
- The major unit is the increment between the scale's tick marks.
- The chart has a second set of tick marks, called the minor tick marks, which may or may not be displayed; if shown, their positioning is determined by the minor unit setting.
- Major tick marks are displayed alongside an axis value, whereas minor tick marks, if present, are not alongside an axis value.
For more information about Charts and Graphs in Excel, please view the full tutorial from the CTL here: Excel Part 2
If you need further assistance, please click the CTL Support Request button on this page.