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](https://i.how-what-advice.com/images/003/image-6009-1-j.webp)
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](https://i.how-what-advice.com/images/003/image-6009-2-j.webp)
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](https://i.how-what-advice.com/images/003/image-6009-3-j.webp)
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](https://i.how-what-advice.com/images/003/image-6009-4-j.webp)
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](https://i.how-what-advice.com/images/003/image-6009-5-j.webp)
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](https://i.how-what-advice.com/images/003/image-6009-6-j.webp)
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](https://i.how-what-advice.com/images/003/image-6009-7-j.webp)
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](https://i.how-what-advice.com/images/003/image-6009-8-j.webp)
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](https://i.how-what-advice.com/images/003/image-6009-9-j.webp)
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](https://i.how-what-advice.com/images/003/image-6009-10-j.webp)
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](https://i.how-what-advice.com/images/003/image-6009-11-j.webp)
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](https://i.how-what-advice.com/images/003/image-6009-12-j.webp)
Step 5. Click Ok
Changes made to the chart will be saved.