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.
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.
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.
The functionality described above is just one of 300 powerful functions of Kutools for Excel.
Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.