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 with that situations.

1. Consider the data with multiple data series.

data with multiple data series

2. Highlight data. Go to ribbon. Under Insert option select Scatter chart with lines option.

Scatter chart with lines

3. Now you will have the chart window as shown below.

chart which needs change

4. As you can see in last step all lines clotted at one place. To separate them, right click on any line and select Format Data Series option.

Format Data Series

5. A window will appear like shown below. Select Secondary Axis.

Secondary Axis

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

repeat for all lines

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

Format Axis

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

edit maximum value

9. Here you go with the chart with multiple series.

chart with multiple series ready