2 Easy Ways to Make a Chart with Two Y Axes in Excel

Download Article

A quick guide to adding a secondary Y-Axis to a bar or line graph in Microsoft Excel

Written by Rain Kengly

Last Updated: July 24, 2024 Fact Checked

Download Article

Adding a Second Y-Axis

|

Changing the Chart Type of the Secondary Axis

|

Video

|

Q&A

Do you have a lot of data you need to represent in a Microsoft Excel chart or graph? When you have mixed data types, it can be helpful to put one or more data series on a Y-Axis. Luckily, this can be done in a few simple steps. You'll just need to create the base chart before you can edit the axes. This wikiHow will show you how to add a secondary Y-Axis to a chart in Microsoft Excel using your Windows or Mac computer.

How to Make an Excel Graph with 2 Y Axes

Right-click on a graph and select Change Chart Type.
Select Combo from the graph types.
Click the checkbox for the data you want to show under the Secondary Axis menu.
Select the graph type for each set of data.
Click OK to confirm your settings.

Method 1

Method 1 of 2:

Adding a Second Y-Axis

Download Article

1
Open a workbook in Microsoft Excel. You can use an existing project or create a new spreadsheet.^{[1]
X
Trustworthy Source

Microsoft Support
Technical support and product information from Microsoft.

Go to source}
- You can use Excel to make tables, type formulas, and more.
2
Highlight the data you want to graph. Click and drag over the cells containing the data you want to use in your line graph. If your data isn't already entered, do so now. Be sure to select column headers if you have them.
- To select everything, click the top-left cell of the data. Press CTRL + A (Windows) or Command + A (Mac).
Advertisement
This is at the top toolbar.
This looks like two intersecting line graphs. You can find this in the Charts section.
5
Hover over a graph style. Hover the mouse cursor over a line graph template in the drop-down menu to see what it will look like with your data.
- The first section of graphs has traditional two-dimensional line graphs, while the second has one or more 3D line graphs.
- If you have a lot of data, the preview may take a moment to appear.
Once you decide on a line graph template, clicking it will create your graph in the middle of the Excel window.
Clicking the line once highlights each individual data point on the line. Double-clicking it displays the Format Data Series menu to the right.
This is the Series Options icon. It's at the top of the Format Data Point menu to the right.
It's below the Series Options header in the Format Data Series menu. This immediately displays the line on a secondary axis with the numbers on the right side.

Method 2

Method 2 of 2:

Changing the Chart Type of the Secondary Axis

Download Article

1
Right-click the chart. If you haven't moved your chart, it should be in the middle of the Excel spreadsheet. This will open a drop-down menu next to the chart.
- On Mac, you can use a control-click.
A new window will open. If you aren't already on the Combo tab, find it in the left panel and click it.
To add other lines to the Y-axis, click the checkbox below Secondary Axis at the bottom half of the window.
In addition to graphing a data series on a separate Y-axis, you can also graph it on a different chart type. Use the drop-down menu to select the chart type for each data series in the lower-right corner of the window.
5
Click OK. This will save and apply the changes you made to the chart.
- If you want to change the chart type for the entire chart, click the chart type in the menu to the left of the window and then double-click the chart style in the window.

Community Q&A

Search

Add New Question

Question

I have the vertical columns for the first set of data, but how do I add the horizontal axis for the next set of data?

Community Answer

Right Click in the Chart area. Click the Add Button under the "Legend Entries (Series)" and enter correct cells that have the data you want graphed. Click Edit under "Horizontal (Category) Axis Label" and click okay.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 6 Helpful 11