Download Article
Download Article
This article was co-authored by wikiHow staff writer, Rain Kengly. Rain is a tech writer and editor for wikiHow with over 5 years of professional writing experience. In the past, Rain has worked with other creative writers as a Writing Tutor at San Francisco State University and has published gaming features, guides, and news articles for a variety of media outlets. Rain shares a lifelong passion for writing and gaming and is eager to grow alongside new tech inventions.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 1,061,640 times.
Learn more...
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.
Steps
-
Open a workbook in Microsoft Excel. You can use an existing project or create a new spreadsheet.[1]- You can use Excel to make tables, type formulas, and more.
-
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.[2]- To select everything, click the top-left cell of the data. Press CTRL + A (Windows) or Command + A (Mac).
Advertisement -
Click the Insert tab. This is at the top toolbar.[3] -
Click the graph icon. This looks like two intersecting line graphs. You can find this in the Charts section. -
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.
-
Click a graph style to select it. Once you decide on a line graph template, clicking it will create your graph in the middle of the Excel window. -
Double-click the line you want to graph on a second axis. Clicking the line once highlights each individual data point on the line. Double-clicking it displays the Format Data Series menu to the right.[4] -
Click the icon that resembles a bar chart. This is the Series Options icon. It's at the top of the Format Data Point menu to the right. -
Click the bubble next to "Secondary Axis". 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.[5]
-
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.
-
Click Change Chart Type…. A new window will open. If you aren't already on the Combo tab, find it in the left panel and click it.[6] -
Click the checkbox beside other lines you want to add to the Y-axis. To add other lines to the Y-axis, click the checkbox below Secondary Axis at the bottom half of the window.[7] -
Select the type of chart for each data series. 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. -
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
-
QuestionI 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 AnswerRight 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.
Video
Tips
References
- ↑ https://support.microsoft.com/en-us/office/add-or-remove-a-secondary-axis-in-a-chart-in-excel-91da1e2f-5db1-41e9-8908-e1a2e14dd5a9
- ↑ https://www.geeksforgeeks.org/how-to-make-a-3-axis-graph-using-excel/
- ↑ https://www.geeksforgeeks.org/how-to-make-a-3-axis-graph-using-excel/
- ↑ https://www.sussex.ac.uk/its/help/faq?faqid=255
- ↑ https://www.geeksforgeeks.org/how-to-make-a-3-axis-graph-using-excel/
- ↑ https://support.microsoft.com/en-us/office/add-or-remove-a-secondary-axis-in-a-chart-in-excel-91da1e2f-5db1-41e9-8908-e1a2e14dd5a9
- ↑ https://support.microsoft.com/en-us/office/add-or-remove-a-secondary-axis-in-a-chart-in-excel-91da1e2f-5db1-41e9-8908-e1a2e14dd5a9
About This Article
1. Create a spreadsheet with the data you want to graph.
2. Select all the cells and labels you want to graph.
3. Click Insert.
4. Click the line graph and bar graph icon.
5. Double-click the line you want to graph on a secondary axis.
6, Click the icon that resembles a bar chart in the menu to the right.
7. Click the radio button next to "Secondary axixs.
Reader Success Stories
-
"Brilliant, thanks. If only Office made it easy to find these quick solutions! It's crazy that you have to leave the program and go online to get the answers. Thanks again. "..." more
