Chart with multiple series

In Microsoft Excel, you can create charts with multiple series to display multiple sets of data on the same chart and compare their values. This Excel tutorial will teach you how to handle that situation.

Here’s how to create a chart with multiple series in Excel:

Consider the data sets with multiple data series. Organize your data into columns, with each column representing a set of values that you want to display in the chart. Make sure that the data is organized in a way that makes sense for the type of chart you want to create.

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

You can format the chart to make it look the way you want, including changing the colors, adding labels, and customizing the axis. To format the chart, select it and go to the “Design” tab in the ribbon. Use the options in the “Chart Styles” and “Chart Layouts” groups to change the look of the chart.

See also  How to Make a Polar Chart in Excel

Here you go with the chart with multiple series.

chart with multiple series ready

The chart will display the values for each series side by side, allowing you to compare the values and draw conclusions from the data.