How to Insert a Second Y-Axis in an Excel Chart: 12 Steps

Table of contents:

How to Insert a Second Y-Axis in an Excel Chart: 12 Steps
How to Insert a Second Y-Axis in an Excel Chart: 12 Steps

Video: How to Insert a Second Y-Axis in an Excel Chart: 12 Steps

Video: How to Insert a Second Y-Axis in an Excel Chart: 12 Steps
Video: How To Calculate Z Scores In Excel 2024, November
Anonim

Displaying multiple trend data on a single chart in Excel does help. Unfortunately, if your data has different units, you may find it impossible or difficult to create the necessary graphs. Calm! You can do it. The process of making graphics like this is quite easy! This wikiHow teaches you how to add a second Y-axis to a chart in Microsoft Excel.

Step

Part 1 of 2: Adding a Second Y-Axis

Add a Second Y Axis to a Graph in Microsoft Excel Step 1
Add a Second Y Axis to a Graph in Microsoft Excel Step 1

Step 1. Create a spreadsheet with the existing data

Each record must be added to a separate box with labeled rows and columns.

Add a Second Y Axis to a Graph in Microsoft Excel Step 2
Add a Second Y Axis to a Graph in Microsoft Excel Step 2

Step 2. Select the data you want to graph

Click and drag the cursor to highlight all the data you want to graph. Make sure you mark all data entries and labels.

If you don't want to create a graph from the entire worksheet, you can select multiple boxes by holding down the Ctrl key and clicking each box that you want to use as the graph data source

Add a Second Y Axis to a Graph in Microsoft Excel Step 3
Add a Second Y Axis to a Graph in Microsoft Excel Step 3

Step 3. Click Insert

It's in the menu bar at the top of the page. The “Insert” pane will appear at the top of the Excel window.

Add a Second Y Axis to a Graph in Microsoft Excel Step 4
Add a Second Y Axis to a Graph in Microsoft Excel Step 4

Step 4. Click the icon that looks like the type of graphic you want to create

After that, a graph will be created based on the selected data.

You can also add a second axis to a line graph or bar graph

Add a Second Y Axis to a Graph in Microsoft Excel Step 5
Add a Second Y Axis to a Graph in Microsoft Excel Step 5

Step 5. Double-click the line to which you want to add a second axis

If you click once, each data entry on the line will be marked. If you double click it, the " Format Data Point " menu will be displayed on the right side of the graph.

Add a Second Y Axis to a Graph in Microsoft Excel Step 6
Add a Second Y Axis to a Graph in Microsoft Excel Step 6

Step 6. Click the icon that looks like a bar graph

This icon is the "Series Options" option icon. You can see it at the top of the “Format Data Point” menu, on the right side.

Add a Second Y Axis to a Graph in Microsoft Excel Step 7
Add a Second Y Axis to a Graph in Microsoft Excel Step 7

Step 7. Select the “Secondary Axis” radio button

This button is under " Series Options " in the " Format Data Point " menu. A line on the second axis with a number on its right will be displayed.

Part 2 of 2: Changing the Second Axis Graph Type

Add a Second Y Axis to a Graph in Microsoft Excel Step 8
Add a Second Y Axis to a Graph in Microsoft Excel Step 8

Step 1. Right-click the chart

Charts are usually displayed in the center of an Excel spreadsheet. A new menu will appear next to the line graph.

Add a Second Y Axis to a Graph in Microsoft Excel Step 9
Add a Second Y Axis to a Graph in Microsoft Excel Step 9

Step 2. Click Change Series Chart Type

A graphic editing window will appear after that.

Add a Second Y Axis to a Graph in Microsoft Excel Step 10
Add a Second Y Axis to a Graph in Microsoft Excel Step 10

Step 3. Click the check box next to any other lines you want to add to the Y axis

To add another line to the Y-axis, click the checkbox under "Y-axis", to the right of the series or data series in the lower-right corner of the window.

Add a Second Y Axis to a Graph in Microsoft Excel Step 11
Add a Second Y Axis to a Graph in Microsoft Excel Step 11

Step 4. Select the chart type for each data series

In addition to graphing selected data sets for a separate Y-axis, you can also represent data with other types of graphs. Use the drop-down menus to select a chart type for each data series or series in the lower-right corner of the window.

Add a Second Y Axis to a Graph in Microsoft Excel Step 12
Add a Second Y Axis to a Graph in Microsoft Excel Step 12

Step 5. Click Ok

Changes made to the chart will be saved.

Recommended: