How to Plot Multiple Lines in One Graph in Excel

Get FREE Advanced Excel Exercises with Solutions!

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. In this article, I will show you how to plot multiple lines in Excel in one graph.


Plot Multiple Lines in One Graph in Excel: 3 Easy Steps

This is the dataset for today’s article. We have the sales amount of 2 salesmen. I will plot multiple lines in Excel in one graph to compare the values.


Step 1: Plot a Chart from Insert Tab

The first step is to insert a chart. To do so,

  • Go to the Insert tab.
  • Then go to the Scatter chart.
  • After that, choose a type of chart from the available options.

insert chart to plot multiple lines in excel in one graph

  • Excel will create a blank chart.

insert chart to plot multiple lines in excel in one graph


Step 2: Insert Multiple Graphs

The next step is to add values to create multiple lines. To do so,

  • Right-click your mouse to bring the context bar.
  • Then, click Select Data.

  • Select Data Source window will appear.
  • Click Add.

Add lines to plot multiple lines in excel in one graph

  • Then, give a series name.
  • After that, select C6:C12 as series values.
  • Finally, click OK.

  • Excel will add a series named Mike.
  • After that, select Add again to plot another line.

Add lines to plot multiple lines in excel in one graph

  • Then, give the new series a name.
  • After that, select D6:D12.
  • Finally, click OK.

  • Excel will plot 2 lines.

Add lines to plot multiple lines in excel in one graph

Read More: How to Make a Double Line Graph in Excel


Step 3: Add Values to the Horizontal Axis

The next step is to modify the horizontal axis. To do so,

  • First of all, go to the Select Data Source dialog box.
  • Then, select Edit from Horizontal (Category) Axis Labels.

Modify horizontal axis to plot multiple lines in excel in one graph

  • Axis Labels box will pop up.
  • Select B6:B12 as the range.
  • After that, click OK.

  • Excel will modify the horizontal axis.

Modify horizontal axis to plot multiple lines in excel in one graph


Things to Remember

  • You can add more lines following this method.
  • There are other chart options available for you.

Download Practice Workbook

Download this workbook and practice while going through the article.


Conclusion

In this article, I have explained how to plot multiple lines in Excel in one graph. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below.


Related Articles


<< Go Back To Line Graph in Excel | Excel ChartsLearn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Akib Bin Rashid
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo