It's a good idea to put multiple data trends into one graph.If you have different units in your data, you might not be able to create a graph you need.You can, and it is easy.A second Y axis is added to a graph in Microsoft excel.
Step 1: Make a spreadsheet with your data.
Each data point should be contained in a single cell with rows and columns labeled.
Step 2: Pick the data you want to graph.
To highlight the data you want to graph, click and drag.All data points and labels should be included.If you don't want to graph the entire spreadsheet, you can select multiple cells by clicking on them.
Step 3: Click on the box that says "Insert".
The menu bar is at the top of the page.The insert panel is displayed at the top.
Step 4: You can create a chart type by clicking on the icon that resembles it.
The selected data is used to generate a chart.A second axis can be added to a bar graph.
Step 5: To graph the line on a second axis, double-click it.
Clicking the line highlights individual data points.To see the "Format Data Point" menu, double-click it.
Step 6: The bar chart looks like an icon.
The "Series Options" is an icon.It is at the top of the menu.
Step 7: The radio button should be used for the secondary axis.
"Series Options" is in the Format Data Point menu.This shows the line on a secondary axis with the numbers on the right side.
Step 8: Click it to see the chart.
There is a chart in the spreadsheet.There is a menu next to the chart.
Step 9: You can change the series chart type.
There is a window that allows you to modify the chart.
Step 10: Click next to any other lines you want to add to the Y-axis.
The data series in the lower-right corner of the window can be used to add other lines to the Y-axis.
Step 11: For each data series, choose the type of chart you want.
You can also graph a data series on a different type of chart.In the lower-right corner of the window, use the drop-down menu to choose the chart type for each data series.
Step 12: Click on it.
The changes you made to the chart are saved.Click the chart type in the menu to the left of the window if you want to change it for the entire chart.