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.
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.
- Excel will create a blank chart.
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.
- 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.
- Then, give the new series a name.
- After that, select D6:D12.
- Finally, click OK.
- Excel will plot 2 lines.
- How to Plot Semi Log Graph in Excel (with Easy Steps)
- Plot Sieve Analysis Graph in Excel (with Quick Steps)
- How to Make an X Y Graph in Excel (With Easy Steps)
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
- Then, select Edit from Horizontal (Category) Axis Labels.
- Axis Labels box will pop up.
- Select B6:B12 as the range.
- After that, click OK.
- Excel will modify the horizontal axis.
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.
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.