Easily create a line chart with multiple series in Excel

Kutools for Excel

Normally, when creating a line chart with multiple series, the lines will be displayed in the overlap mode and it’s not easy to compare the series values. The Multiple Series Line Chart utility of Kutools for Excel helps to create a line chart with multiple series, which multiple lines are grouped side by side in the same chart in order to easily compare these multiple sets of values at a glance.

The below screenshot displays the line charts created by Excel and Kutools.

Create a line chart with multiple series

Please do as follows to create a line chart with multiple series in Excel.

1. Click Kutools > Charts > Difference Comparison > Multiple Series Line Chart.

2. In the Multiple Series Line Chart dialog box, please configure as follows.

2.1) Data range: Select all series values except the axis labels and series names in the original data range;

2.2) Axis Labels: Select the cell range you will display as the axis labels in the chart;

2.3) Series name: Select the cells containing the series names in the original data range;

2.4) Click the OK button.

Tips:

(1) If you select the whole data range firstly and then enable the feature, ranges will be recognized and outputted in corresponding boxes automatically.

(2) The number of rows selected in the Data range box must be equal to the number of cells selected in the Axis Labels box.

And the number of cells selected in the Series name box must be equal to the number of columns selected in Data range box.

Then a chart with multiple series lines is created as the below screenshot shown.

Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.