Right-click the vertical axis on an Excel chart, open Format Axis, then adjust bounds, tick intervals, or number format to rescale your data display.
The Y-axis sets the visual scale for every data point in your chart, and a poorly chosen range can flatten trends or exaggerate small changes. Learning how to edit Y-axis in Excel takes about thirty seconds once you know which pane to open — the Format Axis panel holds every control for bounds, units, tick spacing, and number formatting.
What You Can Change on the Y-Axis
The Format Axis pane groups these adjustments into two main tabs. Under Axis Options you control the scale itself — where the axis starts and ends, how often ticks appear, and whether the axis uses a logarithmic scale. Under Number you control how values are displayed: currency symbols, decimal places, percentages, or custom color-coded formats.
- Bounds — the minimum and maximum values shown on the axis
- Units — the interval between major tick marks (and optionally minor ticks)
- Display units — show values in Thousands, Millions, or Billions to shorten large numbers
- Logarithmic scale — compresses exponential data into a readable range
- Floor crosses at — where the horizontal axis crosses the vertical axis
- Number format — currency, percentage, date, or custom codes with color rules
Editing the Y-Axis in Excel: Key Settings Guide
The Format Axis pane is the single control center for every Y-axis change. You reach it by selecting the axis first, then opening the pane through the ribbon or a right-click. Once open, every numeric field accepts typed values — set a Minimum of 0 and a Maximum of 100, for example, and the chart rescales instantly. The pane stays open while you click between settings, so you can test different values without reopening it.
How Do You Edit the Y-Axis Step by Step?
These steps work identically in Excel 365, Excel 2021, Excel 2019, and Excel 2016. The ribbon labels and pane layout are the same across Windows and Mac, though Mac users may find the tab names in a slightly different order.
- Click the chart to activate the Chart Tools ribbon section — you’ll see Design and Format tabs appear.
- On the Format tab, locate the Current Selection group. Click the dropdown at the top and choose Vertical (Value) Axis.
- Click Format Selection directly below the dropdown. The Format Axis pane opens on the right side of the window.
- Under Axis Options, adjust the Minimum and Maximum bounds to set where the axis starts and ends. Change Major unit to control the gap between tick marks.
- Under Number, pick a category like Currency or Percentage, or select Custom to enter a format code. The chart updates in real time as you make changes.
Microsoft’s official documentation for the vertical axis scale covers every field in the pane, including the logarithmic option and display unit label settings.
Y-Axis Settings Quick Reference
| Setting | What It Controls | Typical Use Case |
|---|---|---|
| Minimum / Maximum | Start and end values for the axis | Force a zero baseline for bar charts |
| Major unit | Spacing between primary tick marks | Set 10-unit intervals for clean readability |
| Minor unit | Spacing between smaller tick marks | Add finer reference lines for dense data |
| Display units | Shorthand label (Thousands, Millions) | Shorten large figures on budget charts |
| Show display units label | Adds “Thousands” or “M” near the axis | Clarify that values are scaled |
| Logarithmic scale | Exponential spacing instead of linear | Wide-range data like population growth |
| Floor crosses at | Where the horizontal axis meets the vertical | Set to zero for standard column charts |
Custom Number Formats and Color Coding
The Number section of Format Axis lets you apply any built-in format — currency, percentage, date, or decimal precision. For conditional color coding, use a custom format code with brackets around the condition. The syntax <600"[Red]"0";>=600"[Green]"0 displays values under 600 in red and values 600 or above in green. Excel evaluates the conditions in order, so list the lower bound first. This approach works on any value axis and updates automatically when the source data changes.
Common Mistakes to Avoid
| Mistake | Why It Breaks | How to Fix |
|---|---|---|
| Editing the horizontal axis by accident | The wrong axis changes nothing visible or alters category labels | Select Vertical (Value) Axis from the dropdown in Chart Tools |
| Changing bounds without adjusting the crossing point | The horizontal axis can shift above the floor of the chart | Set Floor crosses at to match your new Minimum value |
| Typing invalid custom format codes | Missing brackets or quotes produce no color change | Use the exact bracket syntax: [Color]"value" |
| Assuming Display Units alters the raw data | The chart labels change but the numbers in your cells stay the same | Check the underlying data separately if you need actual values |
| Using a white shape to hide axis labels | Shapes shift when the chart resizes or prints | Set label font color to white or remove labels via Format Axis |
Faster Ways to Open Format Axis
If the ribbon route feels slow, three shortcuts get you to the same pane quicker. Double-click directly on the Y-axis numbers — the Format Axis pane opens without a single ribbon click. After selecting the axis, press Ctrl+1 on Windows or Cmd+1 on Mac to jump straight to the pane. Right-click the axis and choose Format Axis from the context menu, which works in every Excel version.
Final Checks for a Clean Y-Axis
Before closing the pane, confirm three things. Make sure the Minimum bound matches the lowest value that makes sense for your data — zero for most column charts, the lowest data point for line charts where negative space would mislead. Verify that Display units is set only when large numbers genuinely need shortening; adding “Millions” to a chart that runs from 1 to 100 looks unprofessional. Finally, test your number format by entering a sample value at each extreme — if color coding is active, both conditions should display correctly before you save.
References & Sources
- Microsoft Support. “Change the scale of the vertical (value) axis in a chart.” Covers every field in the Format Axis pane and lists supported Excel versions.