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
Step 1. Create a spreadsheet with the existing data
Each record must be added to a separate box with labeled rows and columns.
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
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.
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
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.
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.
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
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.
Step 2. Click Change Series Chart Type
A graphic editing window will appear after that.
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.
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.
Step 5. Click Ok
Changes made to the chart will be saved.