How to Put Two Sets of Data on One Graph in Excel. ... Select "All Charts," choose "Combo" as the chart type, and then select "Clustered Column - Line," which is the default subtype.

Two-sided graphs require three sets of data: ... The second side scale is added and the Series2 data is converted into a line graph, which is superimposed onto the original bar graph.

Scatter graphs show how two sets of data are related to each other. Data points are plotted on a graph and then a line of best fit is drawn to show the overall trend, close trend The overall ...

Click the "Insert" tab at the top of the window, then click on the line graph icon — it looks like two zigzagging lines with data points on them. 4. Select the chart style that you prefer from ...