Chart with multiple series

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.

data 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.

Scatter chart with lines

Now you will have the chart window as shown below.

chart which needs change

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.

Format Data Series

Adding secondary axis

A window will appear like the one shown below. Select the Secondary Axis.

Secondary Axis

Now repeat for all the lines of data (if needed).

repeat for all lines

To set the axis of the chart, select the right side scale, right-click and select Format Axis as shown below.

Format Axis

Now a window will appear like shown below. In the Axis Option set the Maximum scale according to the highest value of your data.

edit maximum value

Here you go with the chart with multiple series.

chart with multiple series ready

Further reading: 
Scatter Chart
Time Series Graph
Chart with a lot of data