How to Hide Secondary Axis in Excel Without Losing Data

Creating a dual-axis chart in Excel is a fantastic way to display two different data sets on a single graph, especially when they use wildly different scales. But sometimes, that secondary axis adds more clutter than clarity. This article will show you exactly how to hide the secondary axis in your Excel chart without losing the data series it represents, leaving you with a clean, professional-looking visual.

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 Use a Secondary Axis in the First Place?

Before we learn how to hide it, let’s quickly cover why you’d use a secondary axis. Its primary job is to solve a scaling problem. Imagine you're creating a marketing report and want to visualize Website Sessions alongside your Conversion Rate for the past month.

• Your Website Sessions are in the thousands (e.g., 50,000, 75,000).
• Your Conversion Rate is a small percentage (e.g., 1.5%, 2.1%).

If you plot both of these on a single Y-axis scaled from 0 to 80,000, your sessions will look like impressive bars or a dynamic line. Your conversion rate, however, will be a nearly invisible, flat line squished along the bottom of the chart. The insight is completely lost because the scale doesn't fit the data.

By adding a secondary Y-axis (the vertical axis on the right side of the chart), you can assign a different scale to each data series. You can plot the sessions against the primary axis (on the left) and the conversion rate against the secondary axis (on the right). Suddenly, both series are fully visible, and you can clearly see the relationship between them. This is the magic of a "combo" or dual-axis chart.

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

The Problem: When the Secondary Axis Becomes Visual Clutter

The secondary axis is essential for building the chart, but it isn't always necessary for presenting it. Once both lines are plotted correctly, having two separate y-axes can sometimes make a chart feel 'busy' or confusing for the audience, especially one that isn't data-savvy. The goal of a good chart is to communicate information as clearly and quickly as possible, and sometimes, less is more.

Many users want a cleaner look where the focus is on the trends and the relationship between the two data series, perhaps using data labels directly on the chart to show specific values. The immediate, rookie mistake is to click on the secondary axis and hit the "Delete" key. Don't do this!

Hitting "Delete" tells Excel you don't want the axis or the data plotted against it. Your second data series will instantly revert to being plotted on the primary axis, taking you right back to the original scaling problem. The line for your conversion rate will flatten out again, and the data disappears from view.

The solution is not to delete the axis, but to simply make it invisible.

Step-by-Step Guide: How to Properly Hide the Secondary Axis

Here’s the correct, foolproof method to hide your secondary axis while keeping your data perfectly displayed. We'll continue with our example of a column chart showing Website Sessions and a line chart showing Conversion Rate.

Step 1: Create Your Combo Chart

First, make sure your combo chart is set up correctly. If you haven't already:

1. Select your data, including headers.
2. Go to the Insert tab on the Ribbon.
3. In the Charts section, click "Recommended Charts." If a combo chart isn't suggested, click the "All Charts" tab.
4. Select "Combo" from the list on the left.
5. Excel will give you options for each data series. For "Website Sessions," choose a "Clustered Column." For "Conversion Rate," choose a "Line."
6. Crucially, for the "Conversion Rate" series, check the Secondary Axis box.
7. Click OK. You should now have a chart with two vertical axes.

Step 2: Access the "Format Axis" Options

Now, we need to get into the formatting settings for the secondary axis (the one on the right). There are two easy ways to do this:

• Double-click directly on the numbers of the secondary axis.
• Alternatively, right-click on the secondary axis and select Format Axis… from the context menu.

This will open the "Format Axis" pane on the right side of your Excel window. This is where we'll perform all the 'hiding' actions.

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

Step 3: Hide the Axis Line

With the "Format Axis" pane open, start by hiding the vertical line of the axis itself.

1. Click on the Fill & Line icon (it looks like a paint bucket).
2. You’ll see a section called "Line." Expand it if it's not already.
3. Select the radio button for "No line."

The vertical line dissecting the right side of your plot area will immediately disappear. So far, so good.

Step 4: Hide the Axis Labels (The Key Step)

Next, we need to hide the numbers or labels that make up the axis scale. This is the most important step for making the axis invisible.

1. In the "Format Axis" pane, click the Axis Options icon (it looks like a bar chart).
2. Click to expand the Labels section.
3. Find the dropdown menu for "Label Position."
4. Click the dropdown and select "None."

As soon as you do this, all the numbers on the secondary axis vanish. Your chart is already looking much cleaner, but we have one more small cleanup step.

Step 5: Hide the Tick Marks

Tick marks are the small lines that point from the axis labels toward the chart. Even though the labels are gone, the tick marks might still be there, leaving behind small, floating dashes.

1. Still in the Axis Options tab, find and expand the Tick Marks section.
2. You'll see dropdown menus for "Major type" and "Minor type."
3. Change both of them to "None."

And that’s it! The secondary axis is now completely invisible, but your "Conversion Rate" line is still perfectly scaled and displayed. You haven't lost a single bit of data.

Best Practices: Adding Context Back to Your Chart

Hiding the axis cleans up the visual, but now your audience has no frame of reference for the values of your second data series. You need to add that context back in a different, clearer way. Here are two essential finishing touches.

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

Add Data Labels to Your Second Series

Since people can no longer read the values off an axis, placing them directly on the chart is the best alternative.

1. Right-click directly on the line of your secondary data series (your "Conversion Rate" line).
2. From the context menu, select "Add Data Labels."

Excel will add the specific percentage value to each point on the line chart. Now, not only can your audience see the trend, but they also know the exact value at each point without having to interpret an axis. It's often clearer this way.

Use a Descriptive Chart Title and Legend

Your legend clearly labels which series is which, but your title should tell the full story. A title like "Marketing Performance" is vague. A better title would be "Monthly Website Sessions vs. Conversion Rate," which immediately informs the viewer what two metrics they are comparing, clarifying why one is shown in columns and the other as a line with percentile values.

Final Thoughts

Hiding Excel's secondary axis is a simple formatting trick that can significantly improve the clarity and professional look of your reports. By methodically changing the settings for the line, labels, and tick marks to "None," you can remove the visual clutter without impacting the underlying data, making your charts far easier for your audience to digest.

Manually wrestling with Excel chart settings is a daily task that can add up to hours of lost time each week. At Graphed, we help you eliminate this manual work entirely. We let you connect data sources like Google Analytics, Shopify, and Salesforce in seconds. From there, you just describe the dashboard you want in simple, natural language - like "show me a chart comparing sessions versus conversion rate for the last 30 days" - and we build it for you with live, real-time data. To get your time back and go from data to decisions in seconds, you can start building powerful dashboards for free with Graphed today.