Change the Axis Scale in Excel

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.

CTL Support Request

Details

Article ID: 7920
Created
Thu 12/29/22 11:30 AM
Modified
Fri 11/3/23 3:51 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.