FG
💻 Software

How to break the Y axis in an Excel sheet

Fresh5 days ago
Mar 15, 2026232685 views
Confidence Score0%
0%

Problem

I want to break the Y-axis in an Excel sheet. How can I do that? For example, suppose I have the data in a range from 0-7000 and then range from 22000-28000. I want a break in the Y axis from 8000-20000.

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How to break the Y axis in an Excel sheet

Low Risk

You cannot break the y-axis on an Excel chart to show several, non-contiguous ranges but you can change the default range by right clicking on the y-axis and selecting Format Axis... and then changing Minimum and/or Maximum from Auto to Fixed then s…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment