How to Break Y Axis in Excel Bar Chart

When you have a bar chart with one or two data points that are drastically larger than the others, it often squishes the smaller bars, making them difficult to compare. To solve this, you can create a chart with a broken y-axis, allowing you to show both the detailed view of the smaller values and the scale of the large outlier. This guide will walk you through a reliable step-by-step method to build a broken axis bar chart in Excel and discuss when it's the right choice for your data.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

First, Should You Even Use a Broken Axis Chart?

Before we jump into the "how," it's important to understand the "why" and "why not." A broken y-axis is a powerful visualization tool, but it can also be misleading if used improperly. It intentionally distorts the visual scale of your data.

When to consider it:

• You have a significant outlier in your dataset (e.g., sales are mostly in the $1k-$5k range, but one product suddenly hits $50k).
• Removing the outlier isn't an option because it's a critical piece of information.
• The variations among the smaller values are important and need to be clearly visible.

When to avoid it:

• Your audience might misinterpret the chart. If they're just glancing, they might not notice the break and draw incorrect conclusions about the relative size of the bars.
• The exact proportional difference between all bars is the most important message. A broken axis visually breaks this direct comparison.
• A simpler alternative works better. Sometimes, a table, two separate charts, or using a logarithmic scale can tell the story more honestly and clearly.

If you've decided a broken axis chart is the best fit, your goal is to make the break extremely obvious so you're informing, not deceiving, your audience.

Method 1: The 'Paste-and-Overlay' Technique

This is the most common and flexible method for creating a broken y-axis effect. It involves making two separate charts — one for the low values and one for the high outlier — and then carefully layering them to look like a single chart. It might sound complex, but following these steps will make it straightforward.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Get Your Data Ready

Start by organizing your source data. For this example, let's imagine we're looking at monthly sales figures, where November had a massive outlier due to a holiday promotion.

The key here is to create two separate data series for your chart. One will contain the full values for the "bottom" part of the chart, and the other will contain only the outlier value for the "top" part.

Your data in Excel should look something like this:

Notice how the outlier (85,300) is in its own column ("High Value"). The "Low Values" column is blank for November. This separation is what allows us to plot them on different scales.

Step 2: Create the Main Chart (The 'Bottom' Half)

This chart will display all the smaller values and provide the foundation for our final visual.

1. Select all your data, including the headers (in our example, a range from A1 to C6).
2. Go to the Insert tab on the Ribbon, click the bar chart icon, and select a 2-D Clustered Column Chart.
3. You'll get a chart that has orange and blue bars. The "High Value" series will be a single bar, and the "Low Values" series will have a gap where November should be.
4. Right-click on any of the bars and choose Format Data Series. In the pane that opens on the right, under Series Options, set the Series Overlap to 100%. This will make the bars sit in the same position instead of next to each other, closing the visual gap for November.

Your chart now shows all bars in their correct categories. But the scale is still an issue. Let's fix that.

Step 3: Adjust the Vertical Axis for the Bottom Chart

The goal is to "zoom in" on the smaller values. We’ll cut the axis short, just above our highest "low" value.

1. Right-click the vertical (Y) axis on your chart (the numbers on the left) and select Format Axis.
2. In the Format Axis pane, under Axis Options, find the Bounds section.
3. Change the Maximum value to a number slightly higher than your largest 'low' value. In our example, the highest low value is 11,200. Let’s set the maximum to 14,000.

Now, the large bar for November has vanished above the top of the chart, and your smaller bars are clear and easy to read. This is our "bottom" piece.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Create the 'Top' Chart

Next, we need to create a second chart that will only show the top part of our outlier bar.

1. Select the data for your "High Value" series only, including the category headers (in our case, the "Month" and "High Value" columns). It's best to copy this data to a blank space elsewhere in your sheet to create the chart cleanly.
2. Again, go to Insert > Column Chart > 2-D Clustered Column Chart.
3. You'll now have a separate chart showing just the one massive bar.
4. Right-click its vertical (Y) axis and select Format Axis.
5. This time, we need to set the Minimum bound. Set it to a value slightly lower than your outlier value. Our outlier is ~85,000, so let's set the minimum to 80,000. Set the Maximum to something slightly higher, like 90,000. This isolates just the top portion of the bar.

Step 5: Clean Up and Overlay the Charts

This is where it all comes together. We're going to strip down the 'top' chart and place it directly over the 'bottom' one.

On your 'Top' chart (the one with the outlier):

1. Click on the chart title and press delete.
2. Click on the horizontal (X) axis labels and press delete.
3. Click on the gridlines and press delete.
4. Right-click the chart area background and select Format Chart Area. In the pane, set Fill to No fill and Border to No line. The chart should now be completely transparent.

You should be left with just the top snippet of the bar and its vertical axis. Now, simply drag this transparent chart and place it on top of your "bottom" chart. Resize and align it so the bars line up. This part can be a bit fiddly, so use the alignment guides in Excel and your arrow keys for fine-tuning.

Step 6: Add the Break Symbol

To make it explicitly clear that the axis is broken, you need to add a visual indicator. The classic choice is a pair of zigzag or wavy lines.

1. Go to the Insert tab, click on Shapes, and choose a line or a freeform scribble tool.
2. Draw a zig-zag or wavy line. Format it (change color, thickness) to make it look professional. White works well to disguise the axis line underneath.
3. Copy and paste the shape to create a second one. Place these two shapes over the vertical axis to create the "break" effect. It's often helpful to add another break symbol over the outlier bar itself to visually sever it.

Congratulations! You now have a completed broken axis bar chart. It takes a few steps, but the result is a clean, effective visual that tells a complex story.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 2: Using a Stacked Chart Workaround

Another approach, still based on a clever layering, is using stacked columns. This method is useful for less extreme outliers that are close together.

Create three columns. The main lower numbers, another column to highlight higher end outliers, but that are less drastically different — leaving NA() for non-outliers. Lastly, a column full of repeated values equal slightly less than the lower number values to build a "phantom" base height for the secondary level to stack on. This method can be tricky with axes, so the overlay is more straightforward for the average user.

Best Practices to Remember

• Label Everything Clearly: Ensure your title, data labels, and axis titles are descriptive. You could even add a note in your chart title, like "Monthly Sales (Note: Y-Axis Break for November Data)."
• Don't Obscure the Break: The break symbol should be very obvious. Don't try to hide it. Honesty is the best policy in data visualization.
• Stay Consistent: Once you decide on a maximum value for your lower chart's y-axis and a minimum for your upper one, make sure there’s a consistent (if non-linear) jump. Document this logic if needed.

Final Thoughts

Building a broken y-axis chart in Excel requires a manual workaround, as it's not a standard chart type. By layering and formatting two separate charts, you can create a customized, professional visual that highlights both the granular detail of your small data points and the scale of a significant outlier.

We know that spending hours manually creating workarounds in spreadsheets is a huge time sink. That's why we built Graphed. A process like this, which could take 20-30 minutes of careful work in Excel, can be handled instantly. You could simply ask "show me sales by month, but separate November's outlier so I can see the detail in other months," and our AI would intelligently construct the right visualization in seconds, directly from your live data sources, without any chart layering required.