To add a second y-axis to an Excel column chart, select the data series that needs its own scale, open Format Data Series, and choose Series Options > Secondary Axis. In Excel for Microsoft 365 on Windows, you can also use Chart Design > Change Chart Type > Combo and check Secondary Axis beside that series.
What a second y-axis does
A y-axis, also called a value axis, shows the scale used to measure values in a chart. A secondary y-axis adds a separate value scale on the right side of the chart, while the primary y-axis usually remains on the left. Each axis can have its own minimum, maximum, and units.
This is useful when one series has values much larger or smaller than another, or when the series use different units. For example, a chart might show monthly sales in dollars alongside a conversion rate in percent. A single scale would make one of those series hard to read; a second scale lets each use a suitable range.
A secondary axis does not change the underlying data or convert one unit into another. It only changes how the chart maps values to vertical positions. That distinction matters: two lines or columns that appear close together on a dual-axis chart are not necessarily similar in actual size or behavior.
Add a secondary axis to a column chart
- Arrange the chart data in columns or rows with clear headers. Include the category labels, such as months, and the values for each series.
- Select the data and choose Insert > Insert Column or Bar Chart, then select a column chart such as Clustered Column. If the chart already exists, select it.
- Click the particular series that needs the second scale. The first click selects the whole chart; click one of that series’ columns again if necessary to select just the series.
- Right-click the selected series and choose Format Data Series. In the pane, select Series Options, then choose Secondary Axis.
- To label the new scale, select the chart and use Chart Design > Add Chart Element > Axis Titles > Secondary Vertical. Click the title placeholder and enter the unit or measure.
The right-side scale should appear once the series is assigned to it. If the exact commands are hard to find, use the combo-chart route: select the chart, choose Chart Design > Change Chart Type > Combo, select a chart type for each series, and tick Secondary Axis for the one that needs a separate scale. Select OK to apply the change.
Keep both data series as columns
You do not have to change a series to a line to use a secondary axis. In the Combo dialog, choose a column type for both series and check the secondary-axis box for the appropriate one. However, two column series assigned to different axes can be difficult to compare: their columns may overlap or appear in separate positions rather than forming the familiar side-by-side pair.
If the columns overlap, select a column series, open Format Data Series, and review Series Options. Adjust Series Overlap and Gap Width if those controls are available for the selected chart. The result depends on the chart’s series arrangement, so check that every category remains clear and that the legend still identifies the columns correctly. If adjusting the layout makes the bars confusing, use a combo chart with one series as a line instead.
For a chart where the main point is comparing two quantities across the same categories, clustered columns on one axis are usually easier to interpret when the values share units and a reasonable scale. A secondary axis is most helpful when the scales or units genuinely differ, not simply as a way to make a smaller series look more prominent.
Example: sales and conversion rate
Suppose a worksheet contains Month, Sales, and Conversion Rate columns. Sales might range from $8,000 to $15,000, while the rate ranges from 2% to 5%. A column chart using one value axis is a poor fit for these different measurements: the percent values are tiny compared with the sales values, and they may be nearly invisible.
Use Month as the category axis, Sales as a column series on the primary axis, and Conversion Rate as a line series on the secondary axis. Label the left axis Sales ($) and the right axis Conversion rate (%). This communicates both the magnitude of sales and how the rate changes from month to month. The two measures can be viewed together, but the chart does not prove that one causes changes in the other.
For an example with monthly sales of $10,000, $12,000, and $15,000 and rates of 2%, 3%, and 4%, the two scales help both series remain visible. The axis limits should still reflect the data honestly. Starting the rate axis at 1.5% rather than 0% makes small differences look larger, so use a nonzero minimum only when the reason is clear and the axis labels make it unmistakable.
Choose useful axis limits and labels
Excel normally chooses axis bounds and tick intervals automatically. To change them, right-click the relevant axis, choose Format Axis, and use Axis Options to set bounds or units. The controls differ according to the chart and data, but value axes generally provide minimum and maximum bounds and major units. Choose values that include the data and make the scale easy to read.
- Name both measures: Add axis titles with units, such as Revenue ($) and Units Sold, rather than leaving readers to infer what the scales mean.
- Match number formatting to the data: Use percentage formatting for rates, currency for money, and sensible decimal places for measurements.
- Use distinct series styling: A clear line color or marker shape can connect the right-side scale to its series. Keep the legend and axis title consistent with that styling.
- Show scale boundaries clearly: Avoid limits that exaggerate a small change, and do not hide a zero baseline when readers need to compare column lengths as amounts.
In Excel, a secondary value axis is separate from the category axis. The categories—months, products, or locations—are still shared. The second axis is not a second set of dates or labels along the bottom.
When a dual axis is helpful—and when it is not
Use a second axis when a chart needs to display related series with substantially different scales or units, such as temperature and rainfall, revenue and margin percentage, or volume and rate. A common choice is columns for the main quantity and a line for the smaller or differently measured series. The chart title, axis titles, and legend should make the pairing clear.
Avoid a secondary axis if the series can be understood more clearly in separate charts, or if readers mainly need to compare the values directly. Independent scales can make unrelated trends look aligned, and changing one axis limit can make the visual relationship appear stronger or weaker. For important reports, consider showing the scales explicitly and adding the same data in a small table or separate chart for context.
Do not use a second axis just because one series is hidden. First check whether Excel assigned the data correctly, whether the chart type is appropriate, and whether there are blank cells, text values, or unusually large values affecting the scale. A secondary axis can improve visibility, but it does not repair incorrect source data.
Common problems and fixes
- The wrong series gets the axis: Select the series by clicking one of its plotted marks, then check the series name in the Format Data Series pane before choosing Secondary Axis.
- The right axis does not appear: Confirm that a series is actually assigned to Secondary Axis. Then add its title through Chart Design > Add Chart Element > Axis Titles > Secondary Vertical, if a title is also needed.
- The columns cover one another: Two column series on different axes may overlap. Try a column-and-line combo, or adjust series overlap and gap width. Do not assume side-by-side columns will remain clear after moving a series to the second axis.
- The chart looks misleading: Review both axes’ bounds and units. Different scales can create an apparent match between trends even when the underlying values do not support that impression.
- A new data series is missing: Select the chart and use Chart Design > Select Data to check the chart data range and series list before changing axes.
Excel on Mac and Excel for the web
In Excel for Microsoft 365 on Mac, select the series and look for Format Data Series and its axis options, or use the chart-type dialog to choose a combo chart and assign a secondary axis. Ribbon labels and dialog placement can differ slightly from Windows, but the underlying chart setting is the same. If you do not see the option, verify that a data series—not the chart area or an individual data point—is selected.
Excel for the web has chart editing features, but some chart-formatting options can vary by browser and current feature availability. If the secondary-axis control is not available in the web interface, open the workbook in the desktop Excel app, make the chart change there, and save the workbook. The chart can then be viewed in the browser.
Frequently Asked Questions
Can I add a second y-axis without changing my chart to a combo chart?
Yes. Select the series, open Format Data Series, and choose Secondary Axis. A combo chart is an alternative route and is useful when you also want to change one series from columns to a line.
Can both series stay as columns on separate axes?
Yes. Assign one column series to the secondary axis, either in Format Data Series or in the Combo chart dialog. The columns may overlap or be awkward to compare, so inspect the result and consider changing one series to a line.
How do I add a label to the right y-axis?
Select the chart and choose Chart Design > Add Chart Element > Axis Titles > Secondary Vertical. Click the title box that appears on the right and type a descriptive label with the unit.
Why is my secondary axis on the left?
The primary value axis is normally on the left and the secondary one on the right. Check which series is assigned to each axis and whether both axes are displayed. In Format Axis, inspect the axis and series settings if the chart’s layout differs from what you expect.
Does a secondary axis change my worksheet values?
No. It changes the scale used to display a chart series, not the values in the worksheet. The data remains the same, but visual comparisons can change because each axis has its own scale.
Related
- Excel Named Ranges: How They Work and When to Use Them
- Excel Named Range Table: How They Work and When to Use
- Excel Named Range for a Table Column: How It Works
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Gantt Chart Formula: Build a Timeline BarThe core Excel Gantt chart formula is =AND(H$1>=$B2,H$1<=$C2). Apply it as a conditional-formatting rule to the timeline grid:…
- Excel Chart Logarithmic Scale: Setup and TroubleshootingTo add a logarithmic scale to an Excel chart in Microsoft 365 for Windows, select the chart’s numeric…
- Excel Dashboard Images: Add, Format, and Keep Them ClearTo add an image to an Excel dashboard in Microsoft 365 for Windows, select Insert > Pictures >…
- Data Mapping in Excel for Org Charts: A Practical GuideTo map employee data in Excel for an org chart, make a table with one row per person…
- Excel Histogram Formulas: Calculate Bin CountsTo apply a formula to histogram data in Microsoft Excel for Microsoft 365 on Windows, put your numeric…
- Excel Logarithmic Trendline Formula and How to Use ItThe Excel logarithmic trendline formula is the model y = a × ln(x) + b, where Excel estimates…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.