How to Add an Axis to a Chart in Excel

Building a chart in Excel is straightforward, but it loses all meaning if you can't tell what you're looking at. The horizontal and vertical axes anchor your data, giving it the context it needs to tell a story. This guide will show you how to add, restore, and format primary axes and, more importantly, how to create powerful comparison charts by adding a secondary axis.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

What Are Chart Axes in Excel?

Think of axes as the "x" and "y" from your high school math class. They are the reference lines from which your data is measured and plotted. In most Excel charts, you'll work with two primary axes:

• The Horizontal Axis (X-axis): Also known as the category axis, this line typically runs along the bottom of the chart. It usually displays categories of data, such as months, product names, or sales regions.
• The Vertical Axis (Y-axis): Also known as the value axis, this line runs up the left side of the chart. It displays the numerical values corresponding to your categories, such as sales figures, website visitors, or temperature readings.

So, why would you ever need another one? That’s where the secondary axis comes in. A secondary axis is an additional value axis (a second Y-axis) that appears on the right side of the chart. It lets you plot two different data series on the same chart, even if their values are on completely different scales.

Why a Secondary Axis is So Useful

Imagine you're a marketing manager analyzing a recent campaign. You want to see the relationship between your monthly ad spend (large numbers, maybe in the thousands of dollars) and your click-through rate (CTR) (small numbers, represented as a low percentage).

If you plot both on a single vertical axis, your CTR data would look like a nearly flat line at the bottom, completely dwarfed by the ad spend data. The chart would be useless because the scale required for the ad spend makes the CTR variations invisible. By adding a secondary axis, you can plot ad spend against the left-side axis (scaled in thousands of dollars) and CTR against the right-side axis (scaled from 0% to 5%). Suddenly, you can see how changes in spending directly impact your click-through rate, all within one clear, easy-to-understand visual.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

First Things First: Adding a Missing Primary Axis

Sometimes, an axis gets accidentally deleted or doesn't appear by default with a certain chart template. Getting it back is simple. If your chart is missing its horizontal or vertical guide, you can restore it in just a few clicks.

Here’s how to add or bring back a primary axis:

1. Click on your chart to select it. When selected, you'll see a green "+" (Chart Elements) icon appear at the top-right corner of the chart.
2. Click the "+" icon to open the Chart Elements menu.
3. Hover over Axes. You’ll see a small arrow appear to the right.
4. Click the arrow to expand the options. From here, you can check or uncheck the boxes for Primary Horizontal and Primary Vertical to show or hide them.

This is the quickest way to toggle your main axes on and off. Now, let’s get to the main event: adding that powerful secondary axis.

Step-by-Step Guide: How to Add a Secondary Axis in Excel

Creating a chart with a secondary axis, often called a "combo chart," is one of the most effective ways to show the relationship between two different types of data. Let's walk through it with a practical example: plotting monthly Revenue and Units Sold.

Step 1: Get Your Data Ready

First, make sure your data is organized neatly in your spreadsheet. For our example, let's set up a simple table with three columns: Month, Revenue, and Units Sold.

Notice that Revenue is in the tens of thousands, while Units Sold is in the hundreds or low thousands. These different scales make them perfect candidates for a secondary axis.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 2: Create the Initial Chart

Highlight your entire data set, including the headers. Then, go to the Insert tab on the Excel ribbon. In the Charts group, select a chart type. A clustered column chart is a good starting point.

• Select your data (from 'Month' to the last data point).
• Go to Insert > Recommended Charts, or pick a 2-D Column Chart.

Excel will generate a chart with two sets of columns for each month. As expected, the Units Sold columns will look tiny compared to the Revenue columns. Time to fix that.

Step 3: Move One Data Series to the Secondary Axis

Now, we'll tell Excel to plot the Units Sold data against a new axis on the right side.

1. Right-click on the data series you want to move. In our case, click on one of the Units Sold columns (the small ones). Make sure you have selected the entire series of columns and not just one.
2. From the context menu that pops up, select Format Data Series....
3. A Format Data Series pane will open on the right side of your screen. Under Series Options, you will see a section called Plot Series On.
4. Select the Secondary Axis radio button.

Immediately, you'll see a second vertical axis appear on the right side of your chart, scaled appropriately for your Units Sold data. The Units Sold columns will now be appropriately sized relative to their own axis. However, the chart can still look a bit confusing with two sets of overlapping columns.

Step 4: Create a Combination Chart for Clarity

The best way to display two types of data like this is to change the chart type for one of the series. Representing Units Sold as a line over the Revenue columns is a classic and highly readable approach.

1. Right-click the data series you just moved to the secondary axis (Units Sold columns).
2. From the menu, choose Change Series Chart Type....
3. An All Charts dialog box will open with the Combo section automatically selected. Here, you'll see both of your data series listed ("Revenue" and "Units Sold").
4. For the Units Sold series, click the Chart Type dropdown menu and select Line. Ensure the checkbox for Secondary Axis next to Units Sold remains checked.
5. The preview window will show you exactly what the final chart will look like. If it looks good, click OK.

You now have a polished combination chart! It clearly displays monthly revenue as columns (measured against the primary left axis) and the number of units sold as a line (measured against the secondary right axis).

Customizing Your Axes to Make Them Understandable

Just adding an axis isn’t enough, you need to make sure anyone looking at your chart knows exactly what each axis represents. Unlabeled axes are a common source of confusion.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Add Clear Axis Titles

This is non-negotiable for charts with a secondary axis. Your audience needs a-glance clarity.

1. Click your chart, then click the "+" (Chart Elements) icon.
2. Hover your cursor over Axis Titles and click the arrow to expand options.
3. Select Primary Vertical, Primary Horizontal, and Secondary Vertical.
4. Placeholder text boxes will appear next to your axes. Click on each one and type in a descriptive title, like "Monthly Revenue ($)" for the left axis and "Number of Units Sold" for the right axis.

Format the Axis Scale and Numbers

Excel does a pretty good job of setting the scale automatically, but sometimes you need more control.

• Setting Bounds: Right-click on the axis you want to change (e.g., the right vertical axis) and choose Format Axis.... In the pane that opens, you can set the minimum and maximum bounds to focus on a specific range or start the axis at zero.
• Changing Number Formats: In the same Format Axis pane, scroll down and expand the Number section. Here, you can change the format to Currency, Percentage, Scientific, or adjust the number of decimal places. This is crucial for making your axis labels clean and easy to read.

Common Mistakes to Avoid

Adding a secondary axis is a great skill, but it's easy to create a chart that’s more confusing than helpful. Keep these best practices in mind:

• Symmetry in Color: Ensure the color of your axis title and labels matches the color of the data series it represents. If your Units Sold line is orange, make the "Number of Units Sold" axis title on the right also orange. This creates a strong visual link. You can change text color by selecting the text box and using the standard font color tools.
• Avoid Double Column/Bar Charts: A secondary axis combo chart with two sets of columns can be messy and hard to read. Pairing a column or bar chart with a line chart is almost always the clearest option.
• Don't Overcomplicate It: While you can technically add more data series, try to limit your secondary axis charts to two. A chart showing one metric on a primary axis and one on a secondary is potent. Adding a third or fourth just creates visual clutter.
• Always Include a Legend: Even with axis titles, a legend is vital. Excel usually adds one automatically, but if not, use the "Chart Elements" menu (+) to add one. It clearly labels which line or which columns belong to which data set.

Final Thoughts

Mastering chart axes in Excel, especially the secondary axis, elevates your data reporting from basic to insightful. It allows you to weave together two different data stories in a single visual, exposing relationships and trends that would otherwise be hidden. Follow the steps above, focus on clear labeling, and you'll be creating professional, high-impact combo charts in no time.

Pulling data, cleaning it up in a spreadsheet, and painstakingly formatting charts is a familiar routine for many teams. At Graphed, we felt this manual reporting grind took away too much time from actual analysis. That's why we built a tool that connects directly to sources like Google Analytics, Shopify, and your CRM, and lets you create real-time, multi-metric dashboards and charts just by describing what you want to see. Instead of battling with Excel’s chart settings, you can ask for a chart comparing ad spend and conversion rate, and get a live-updating visual in seconds, no CSVs required.