Excel still doesn’t offer a built-in “axis break” option for bar charts. What you can do instead is fake it—by splitting the axis into two ranges and using series values that create the visual gap where the break should be.
This guide shows the simplest, most repeatable workaround that works in modern Excel builds (Microsoft 365, plus Excel 2019/2021). You’ll end up with a bar chart that visually communicates discontinuity without misleading the data labels.
As an Amazon Associate I earn from qualifying purchases.
Follow Method 1 if you want the cleanest result with the least wrestling. Use the alternate methods when your dataset or chart layout doesn’t fit the first approach.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Does Excel Really Let You Break a Bar Chart Axis?
No—Excel does not include a native axis-break feature for typical bar/column charts. Even in current Microsoft 365 versions, the “break axis” controls you might find in some visualization tools are not part of standard Excel chart formatting.
#1 Best Overall
So the practical solution is to simulate the break by splitting the axis range (bottom and top sections) and stacking series so the chart renders a gap.
What You Need Before You Start
- A bar chart dataset where you want to show small values and much larger values on the same category list.
- Clear breakpoints (for example: values from 0–50 and values from 200–1000). This is where the “gap” will appear.
- Basic comfort with Excel charts: adding series, switching chart type, and formatting axes.
For the cleanest results, keep your categories consistent (no extra blank categories) and decide your break size ahead of time.
Method 1 (Simplest): Fake a Broken Axis with a Combo/Stacked Setup
This is the most common Excel workaround because it’s repeatable: you create two bar series that represent the “bottom” and “top” ranges. Then you stack them and draw visual break marks.
Step 1: Prepare two copies of your data (top and bottom ranges)
Assume your data looks like this: Category in column A, Value in column B. Pick a break range you want to hide. Example: you want to break between 50 and 200.
Create two helper columns (say in C and D): Value_Bottom and Value_Top.
| Condition | Value_Bottom | Value_Top |
|---|---|---|
| Value <= 50 | =Value | =NA() (or #N/A) |
| 50 < Value < 200 | =NA() (or 0 depending on your approach) | =NA() (or 0 depending on your approach) |
| Value >= 200 | =50 (or a constant “cap” for stacking) | =Value-50 (adjusted so the top starts after the break) |
Recommended: Use #N/A (via =NA()) for segments you want Excel to skip. This prevents unwanted bars from filling the break area.
Example formulas (adjust cell references to your sheet):
Recommended Free Tools
Value_Bottom (C2):=IF(B2<=50,B2,NA())Value_Top (D2):=IF(B2>=200,B2-50,NA())
If you have values between 50 and 200, you can either exclude them entirely (show nothing) or decide where they should land visually. Most people exclude them so the “gap” reads clearly.
Step 2: Create the chart with two series that “skip” the gap
- Select your Category column (A) and both helper columns (C and D).
- Insert → Column Chart (choose Clustered Column first).
- Click the chart and open Chart Design → Change Chart Type.
- Switch to Stacked Column (or a combo setup that supports stacked behavior). The exact menu name can vary slightly by version, but you’re aiming for stacked bars.
- If Excel labels the series, ensure it shows two series: Value_Bottom and Value_Top.
The stacked design makes bottom pieces reach the break boundary, while top pieces start after it.
Step 3: Add the visual break marks
Excel won’t automatically draw axis-break zigzags. You’ll add them with shapes.
- Go to Insert → Shapes and choose the zigzag (or use a “broken” look via a small line or custom shape).
- Place the break mark on the y-axis area where the missing range would be (between the bottom range top and the top range start).
- Rotate/resize so it matches the thickness and style of the axis line. Use Format Shape to set fill to match the axis color (usually black or dark gray).
- Add one break mark (simple), or two marks (more common), positioned to look like a discontinuity.
Tip for alignment: lock the shape to the chart area by setting it to “move and size with cells” if that option is available in your Excel build.
PC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchStep 4: Format the axis and series so the illusion holds
- Right-click the y-axis and choose Format Axis.
- Set Bounds:
- Minimum: 0
- Maximum: pick a value that fits your biggest series (for example, if your max value is 1000, set Maximum to 1000 or slightly above).
- Set Major unit so the tick marks look consistent with your data labeling. If you used a cap of 50 and adjusted top values by subtracting 50, your top bars won’t represent raw values directly on the axis unless you also format labels carefully. Many creators prefer to show axis ticks that match the adjusted stacking.
- For series styling: make both helper series use the same color as your original chart color scheme (so users read it as one bar).
- Remove the legend if it confuses readers, or keep it if you’re teaching the method.
Data labels: If you add labels, Excel labels will show the helper values (adjusted). To avoid misleading labels, either omit labels or add custom labels from the original Value column.
Rank #3
Method 2 (Alternate): Use an Axis Split by Rescaling the Scale (No Extra Categories)
This method is useful when you can’t or don’t want to stack two series, or when your chart layout needs to stay very close to the original. It uses rescaling so the axis looks “broken” even though Excel is still continuous.
Step 1: Choose breakpoints and compute adjusted values
Example: you want a break between 50 and 200. Let:
- Lower cutoff = 50
- Upper cutoff = 200
- Gap width = Upper cutoff – Lower cutoff = 150
Create an Adjusted Value column that compresses the gap. One straightforward approach is to map values above the upper cutoff down by the gap size you’re hiding.
- If B2 <= 50:
Adjusted = B2 - If B2 >= 200:
Adjusted = 50 + (B2 - 200) - If 50 < B2 < 200: either hide or map to 50 (your choice)
Formula example:
Adjusted Value (C2):=IF(B2<=50,B2,IF(B2>=200,50+(B2-200),NA()))
Now your adjusted data creates the visual jump.
Step 2: Build the chart and set min/max for each axis section
- Create a new bar chart using Categories and the Adjusted Value column only.
- Right-click the y-axis → Format Axis.
- Set axis bounds to cover your adjusted range (not the raw range). This usually means Maximum becomes smaller than your raw maximum because you compressed the gap.
Because your y-axis now represents adjusted units, you’ll need to either (a) add a custom axis label note, or (b) avoid showing numeric y-axis values unless you also implement custom tick labels.
Step 3: Add break marks and align gridlines
- Insert the same zigzag break mark shape in the y-axis gap area.
- Ensure gridlines don’t imply that values exist in the broken range. If they do, adjust Major unit or hide gridlines temporarily.
- If your chart uses data labels, keep them tied to the original raw values (use labels from your raw Value column rather than Adjusted Value).
Method 3 (Quick for One-Offs): Draw the Break Using Shapes Over the Chart
If you only need a visual “break” and you’re okay with the axis being technically continuous, this method is fastest. It’s a presentation hack, not a mathematically clean split.
- Build your standard bar chart from the raw values.
- Insert zigzag/break shapes exactly where the discontinuity should appear.
- Optionally add a text box near the axis: “Axis break indicates omitted values between 50 and 200.”
Use this only when the audience doesn’t require strict numeric correctness. For reports, the stacked/fake axis methods are usually safer.
Common Mistakes (and How to Fix Them Fast)
- Bars fill the break gap instead of skipping it. Use
#N/Awith=NA()for the series segments you want Excel to omit. - Data labels show adjusted helper numbers. Don’t label helper series directly. Either hide labels or label with the original raw Value column.
- Series colors don’t match. Both helper series should share the intended palette so the bar still looks like one measure.
- Axis tick marks look inconsistent. Re-check how you chose your cap value (example: 50). Then update y-axis maximum/major unit to match the adjusted scale.
- Break marks float when you resize the chart. Set the shape behavior to move and size with the chart, or group shapes and move them together.
Troubleshooting: When the Chart Looks Wrong
Problem: Nothing disappears where the axis should break
Check your helper formulas. If you used 0 instead of NA(), Excel will still draw bars. Replace the gap-range outputs with =NA().
Rank #4
Problem: The stacked bars don’t align to the breakpoint
Reconfirm the constant cap used in your helper series (example: Value_Top = Value-50 and Value_Bottom = 50 for values above the upper cutoff). Off-by-one mistakes in breakpoints are common.
Do these 3 things before closing this tab:
1Scan for outdated or missing drivers - takes under a minute2Clear out junk files and repair common Windows errors3Fix the driver behind crashes, sound loss and screen glitchesProblem: The y-axis maximum is too small and clips bars
Increase Format Axis > Bounds > Maximum to fit the tallest stacked bar. In stacked charts, the visual height equals the sum of helper series values, not the original raw value.
Problem: Excel can’t find the right chart type
Try creating the chart from scratch: Insert → Column chart → select a stacked variant, then reassign series to the helper columns. Some chart type conversions can reset series incorrectly.
Problem: You need this to update when data changes
Prefer using table ranges (select your dataset → Insert → Table). If the helper columns reference table cells, the chart often updates automatically. If it doesn’t, verify that the chart’s series still points to the table columns, not fixed ranges.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Comparisons: Which Method Should You Use in 2024?
| Method | Accuracy | Visual Quality | Best When |
|---|---|---|---|
| Method 1: Stacked fake axis | High (if labels are handled correctly) | High | You want a report-ready chart with a true gap illusion |
| Method 2: Rescaled axis | Medium (axis numbers become “adjusted”) | Medium to High | You want simpler chart structure |
| Method 3: Shapes only | Low (presentation-only) | Medium | One-off slides where speed beats numeric strictness |
If you’re publishing or sending this as a formal visualization, Method 1 is usually the best balance of effort and correctness.
FAQs
Can I break the axis on a bar chart automatically?
No. Excel doesn’t provide an automatic axis-break option for standard bar/column charts. You have to use a workaround like the stacked helper-series method.
Will this work in Excel for Microsoft 365 and older versions?
Yes for the core approach. The menu labels for chart type changes can vary between Microsoft 365, Excel 2019, and Excel 2021, but stacked series + helper columns is broadly compatible.
How do I keep tooltips and data labels truthful?
Don’t rely on labels generated from helper series values. Either hide labels or set labels to the original raw Value column using a custom labeling range. Tooltips will still reflect the underlying series values, so double-check what you want users to see.
What breakpoints should I choose?
Pick breakpoints based on meaningful thresholds in your data (for example, a regulatory limit, a business meaningful threshold, or the point where values become so large that small variation becomes invisible). Avoid choosing breakpoints purely to make bars look better.
My data includes zeros and negatives—does the method still work?
It can, but you need to rethink the cap/offset logic. If your chart spans negative values, the “axis split” math must reflect the sign. For negative-to-positive ranges, consider separate handling in helper formulas and carefully test the stacking.
Bottom Line
Excel doesn’t have a native axis-break feature, but you can still create a convincing broken-axis bar chart by splitting the data into helper series and stacking them so the gap is rendered as missing.
For most teams in 2024, Method 1 is the simplest path to a clean, report-ready result—especially when you also avoid misleading numeric labels by tying labels to the original data.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Repair Windows errors before they cause bigger problemsFix Now →
