How to Hide 0 Value in Excel Chart Axis

Nothing clutters an otherwise clean Excel chart like a stray "0" sitting at the bottom of an axis. Whether it's for aesthetic preference or because a zero value isn't relevant to your data, getting rid of it can instantly make your visualization more professional and easier to read. This guide will walk you through several effective methods to hide that zero value on your Excel chart axis, starting with the simplest trick and moving on to more advanced options for specific situations.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Would You Want to Hide the Zero on a Chart Axis?

Before diving into the "how," it helps to understand the "why." You might find yourself wanting to remove the zero for a few common reasons:

• Improved Readability: Sometimes, the zero is simply unnecessary visual noise. Hiding it declutters the axis, especially on smaller charts or dashboards where space is limited.
• Irrelevant Data Point: For some datasets, a value of zero is impossible or meaningless. For example, if you're charting customer satisfaction scores on a scale of 1 to 5, the zero on the axis serves no purpose.
• Focusing the Scale: If all your data points are significantly higher than zero (e.g., all values are above 1,000), starting the axis just below your minimum value can provide a more magnified and detailed view of the data's fluctuations.

Whatever your reason, there's a simple solution waiting for you in Excel.

Method 1: The Quickest Fix with Custom Number Formatting

This is by far the most popular and versatile method for hiding the zero on a chart axis. It works by applying a special format that tells Excel to display nothing whenever it encounters a zero value. The best part is that it only changes the appearance of the axis label, it doesn't alter your underlying data or the chart's structure in any way.

Let's walk through it step-by-step.

Step-by-Step Instructions

1. Select the Axis: First, open your Excel sheet and click on the vertical axis (also known as the Y-axis) of your chart where the zero value is displayed. You should see a box appear around the axis labels.
2. Open the Format Axis Pane: Right-click on the selected axis. From the context menu that appears, choose Format Axis.... This will open a settings pane on the right side of your Excel window.
3. Navigate to the Number Settings: In the "Format Axis" pane, find the icon for "Axis Options" (it usually looks like a small bar chart). Under this selection, expand the section labeled Number.
4. Apply the Custom Format Code:

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

How Does This Magic Code Work?

It's not magic, just clever formatting! Excel's custom number formats are structured in a specific way, separated by semicolons. The structure typically follows this pattern:

[FORMAT FOR POSITIVE NUMBERS],[FORMAT FOR NEGATIVE NUMBERS],[FORMAT FOR ZERO]

When we use the code #,##0,-#,##0,, we are telling Excel:

• For positive numbers, display them with a comma separator (#,##0).
• For negative numbers, display them with a preceding minus sign and a comma separator (-#,##0).
• For zero values, do... nothing. By leaving the third section after the second semicolon completely blank, we effectively tell Excel to display an empty string, making the zero invisible.

You might also see another common format used for this, 0.00,-0.00,, which achieves the same thing but includes two decimal places. The choice is yours based on how you want to format the other numbers on your axis.

Method 2: Remove Zeros from the Data Using the NA() Formula

What if you don't just want to hide the zero label on the axis, but you also want your chart to ignore data points that are zero? This is especially common with line charts, where a zero value can cause a dramatic dip to the bottom of the chart that you might want to avoid.

In this scenario, the custom number format trick won't work, because it only affects the axis labels. Instead, we can use a formula to intercept the zeros in our source data and replace them with something Excel's charts know how to ignore: the #N/A error.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Creating a "Chart-Friendly" Data Column

This method involves creating a new helper column next to your original data. Don't worry, it's easier than it sounds.

1. Set Up a Helper Column: Let's say your sales data is in column B, starting in cell B2. Create a new column next to it — let's call it "Chart Data" in column C.
2. Enter the IF/NA() Formula: In the first cell of your helper column (C2), enter the following formula:

=IF(B2=0, NA(), B2)

This formula instructs Excel to check the value in cell B2. If it's 0, the formula returns NA(), which produces the #N/A "Not Available" error. If B2 is any other value, the formula simply returns that value.

1. Drag the Formula Down: Click on the small square at the bottom-right corner of cell C2 (the fill handle) and drag it down to apply the formula to all of your data. Your helper column will now perfectly mirror your original data, but with #N/A in place of every zero.
2. Update Your Chart's Data Source: Now, simply update your chart to use this new "Chart Data" column (Column C) instead of the original one (Column B). You can do this by right-clicking the chart, selecting "Select Data," and editing the data series range to point to your new column.

Now, your chart will behave as if the zero-value data points don't even exist. For a line chart, this means the line will bridge the gap between the points before and after the zero, rather than dipping down.

Refining Your Line Chart's Appearance

Occasionally, replacing zeros with #N/A can create visible gaps in your line chart. Excel gives you an easy way to control this behavior.

1. Right-click on your chart and choose Select Data.
2. In the "Select Data Source" window, click the button at the bottom-left corner labeled Hidden and Empty Cells.
3. A new dialog box will appear. You'll see an option for "Show #N/A as an empty cell." Below this, you can choose how your chart handles empty cells. Select Connect data points with line.
4. Click OK on both windows.

This setting ensures that even though you've removed the zero points, your line chart remains a single, continuous line, giving you a much cleaner trend visual.

Method 3: Adjust the Axis Minimum Bounds

The third method is simpler but should be used with caution, as it fundamentally changes the scale of your chart's axis. This technique works best when all of your data values are much greater than zero, and you want to "zoom in" on your data's range.

For example, if your report tracks website sessions, and the number is always between 10,000 and 12,000, your chart's default axis might start at 0. This can flatten the visual appearance of important fluctuations. By changing the minimum bound, you can focus the chart on where the action really is.

How to Change Axis Bounds

1. Right-click the vertical axis needing adjustment and select Format Axis....
2. In the "Format Axis" pane, make sure you are in the "Axis Options" tab (the bar chart icon).
3. At the top, you'll see a section called Bounds. You'll see entries for "Minimum" and "Maximum."
4. By default, the Minimum is likely set to "Auto" or 0.0. Simply type a new, larger value into the Minimum box. For instance, if your data's lowest point is 250, you might set the minimum bound to 200.
5. Press Enter, and the chart will redraw its axis, eliminating the zero and scaling up the visual representation of your data.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

A Word of Caution:

Be mindful of data integrity. Setting a high minimum bound on a chart can exaggerate small changes and be misleading if not clearly labeled. While it's fantastic for visual clarity in some cases, always consider if it honestly represents your data's story. If a zero or near-zero outcome is possible and meaningful, this is probably not the right method to use.

Which Method Should You Choose? A Quick Summary

Feeling a bit overwhelmed? Here's a quick cheat sheet to help you decide which approach is right for you:

• For a purely cosmetic change: If you just want to remove the "0" label for a cleaner look without affecting anything else, use Method 1: Custom Number Formatting. It's fast, easy, and reversible.
• To stop zeros from plotting on a line/scatter chart: If you want your chart to completely ignore rows that contain a zero, use Method 2: The IF/NA() Formula. This is perfect for avoiding misleading dips in trendlines.
• To re-scale a chart and "zoom in" on your data: If all of your data is far from zero and you want to highlight subtle variations, use Method 3: Adjusting Axis Bounds. Just be careful not to mislead your audience.

Final Thoughts

Mastering small tweaks like hiding the zero on an Excel chart axis moves your reporting from functional to professional. Whether you choose a simple formatting trick, a smart formula, or a rescale of the axis, you now have the tools to make your charts clearer, cleaner, and more impactful. The right technique always depends on what story you want your data to tell.

Of course, building sharp-looking reports shouldn't feel like wrestling with formatting options. That's why we built our platform to do the heavy lifting for you. With Graphed, you connect data sources like Google Analytics, Shopify, or Facebook Ads and simply tell us what you want to see in plain English. We instantly generate clean, real-time dashboards so you can spend less time fighting with axis bounds and more time making smart decisions based on your live data.