When and why you need a second axis
A second axis in Excel lets you plot two data series that use different scales on the same chart. This matters when one column contains numbers in the hundreds and another contains numbers in the thousands — if you try to show both on a single axis, the smaller values disappear into the bottom of the chart and become unreadable.
The most common example is comparing sales revenue (in dollars) against customer count (in units) over the same time period. Revenue might range from $50,000 to $200,000 while customer count ranges from 100 to 500. Without a second axis, the customer line flattens into a flat line at the bottom because Excel scales everything to fit the revenue numbers.
Excel calls the first axis the primary axis and the second one the secondary axis. You assign one data series to each, and they sit on opposite sides of the chart — left and right for column charts, or bottom and top for bar charts.
Key Takeaways
- A second axis solves the problem of two data series with very different scales appearing on the same chart.
- You create a second axis by right-clicking a data series in an existing chart and selecting "Format Data Series".
- In the Format Data Series pane, you change the series to use "Secondary Axis" under the Series Options tab.
- After adding a secondary axis, both axes appear on the chart automatically, and you can format each one separately.
- The secondary axis label appears on the opposite side of the chart from the primary axis, making it clear which scale applies to which data.
Create your chart first with both data series
Before you can add a second axis, you need a chart that already contains both pieces of data. Start by selecting the data range that includes your labels and both columns you want to compare — for example, dates in column A, revenue in column B, and customer count in column C.
Go to the Insert tab at the top of Excel and click Chart. Excel opens a dialog showing chart type options. Choose the type that makes sense for your data — usually a column chart or line chart works well for comparing two series over time. Click OK or Create depending on your Excel version.
Excel builds the chart and places it on your worksheet. At this point, both data series appear on the same axis, and one or both may look distorted because their scales don't match. This is the moment to add the second axis.
Right-click the data series that needs its own scale
Click directly on the chart to select it. The chart gets a border around it and you see the Chart Design and Format tabs appear in the ribbon at the top.
Now click on the data series (the line, bars, or points) that represents the smaller numbers — the one that looks flattened or hard to read. In the revenue and customer example, you would click on the customer count line or bars. When you click it correctly, all the data points in that series highlight with small squares or circles around them.
Right-click on the highlighted series. A menu appears with formatting options. Look for and click Format Data Series. This opens a pane on the right side of your screen with formatting controls.
Switch the series to the secondary axis
In the Format Data Series pane on the right, look for the Series Options tab — it usually shows a chart icon. Click it if it is not already selected.
Scroll down in this pane until you see a section labeled Plot Series On or similar wording. You will see two radio button options: Primary Axis (currently selected) and Secondary Axis. Click the Secondary Axis radio button.
As soon as you click it, the chart updates. The data series you selected moves to a new scale on the opposite side of the chart. If you were working with a column chart, the secondary axis appears on the right side. For a line chart, it also appears on the right. The numbers on this new axis match the range of your selected data series, so all the data points become visible and readable again.
Verify both axes are labeled and formatted correctly
Look at your chart now. You should see two different number scales — one on the left (primary axis) and one on the right (secondary axis). Each scale reflects the range of the data series assigned to it.
To make the chart clearer, add axis titles so readers know what each scale measures. Click the chart to select it, then look for the Chart Design tab in the ribbon. Click Add Chart Element and choose Axis Titles, then Primary Vertical to label the left axis. Repeat the process and choose Secondary Vertical to label the right axis. Type a descriptive name for each — for example, "Revenue ($)" and "Customer Count".
You can also format each axis separately. Right-click the numbers on the left axis to format the primary axis, or right-click the numbers on the right axis to format the secondary axis. This lets you change number formats, decimal places, or the range of values shown.
Common formatting choices after adding a second axis
Once your second axis is in place, you may want to adjust how the chart looks. If one data series is bars and the other is a line, the chart becomes easier to read because the visual difference reinforces which scale applies to which data. To change a series type, right-click it and select Change Series Chart Type, then pick a different style for that series only.
You can also adjust the colors of each series to make them visually distinct. Right-click a data series, choose Format Data Series, and look for the Fill & Line tab to change its color. A different color for each series helps readers connect the data to the correct axis.
If the chart legend is confusing, you can move it or remove it. Click the chart, go to Chart Design, click Add Chart Element, choose Legend, and pick a position. Some people prefer to remove the legend entirely and instead label each series directly on the chart itself.
When a second axis is not the right solution
A second axis works well when you have exactly two data series with different scales. If you have three or more series, a second axis becomes confusing because readers cannot tell which series uses which scale.
In those cases, consider creating separate charts instead — one for each pair of related data. Or, if the data series are related but have very different scales, you might normalize them first by dividing each value by its maximum, so all series range from 0 to 1. This lets you show all of them on a single axis without distortion.
Another option is to use a table instead of a chart. A table shows exact numbers and does not require readers to interpret scales or axes at all. If your goal is to communicate precise values rather than trends, a table may serve your audience better than any chart.
Frequently Asked Questions
Can I add more than two axes to a chart?
Excel does not support more than two axes on a single chart. If you need to show three or more data series with different scales, create multiple charts or use a table to display the data instead.
What if both my data series have the same scale?
If both series use similar ranges, you do not need a second axis. A single axis will show both clearly. A second axis only helps when one series is much larger or smaller than the other.
How do I remove the secondary axis if I change my mind?
Right-click the data series on the secondary axis, select Format Data Series, go to Series Options, and click Primary Axis. The series moves back to the primary axis and the secondary axis disappears if no other series uses it.
Why does my secondary axis show in a different position than I expected?
The secondary axis always appears on the opposite side of the chart from the primary axis. For vertical charts, it is on the right; for horizontal bar charts, it is on top. This position is fixed and cannot be moved to match the primary axis side.
Can I change the order of the axes or swap which side they appear on?
No. The primary axis is always on the left (or bottom for horizontal charts) and the secondary axis is always on the right (or top). If you want them in a different arrangement, you would need to rebuild the chart with a different structure.