Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Plot Multiple Lines in One Graph in Excel

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.


Download Practice Workbook

Download this workbook and practice while going through the article.


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

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
  • 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 box 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 lines.

Add lines to plot multiple lines in excel in one graph

Read More: How to Plot Graph in Excel with Multiple Y Axis (3 Handy Ways)


Similar Readings


Step 3: Add Values to Horizontal Axis

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

  • First of all, go to the Select Data Source
  • 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

Read More: Plotting Row Number Instead of Value in Excel (with Easy Steps)


Things to Remember

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

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. Please visit Exceldemy for more useful articles like this.


Related Articles

Akib

Akib

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo