Sometimes, it may be difficult to create a chart with multiple series of data. This Excel tutorial will teach you how to handle that situation.
Consider the data sets with multiple data series.
Inserting a chart with multiple data sets
Highlight data. Go to the ribbon. Under the Insert option, select the Scatter chart with lines option.
Now you will have the chart window as shown below.
As you can see, all lines clotted in one place in the final step. To separate them, right-click on any line and select the Format Data Series option.
Adding secondary axis
A window will appear like the one shown below. Select the Secondary Axis.
Now repeat for all the lines of data (if needed).
To set the axis of the chart, select the right side scale, right-click and select Format Axis as shown below.
Now a window will appear like shown below. In the Axis Option set the Maximum scale according to the highest value of your data.
Here you go with the chart with multiple series.
Further reading: Scatter Chart Time Series Graph Chart with a lot of data