Open In App

How to Plot Multiple Lines on an Excel Graph?

Last Updated : 14 May, 2024
Improve
Improve
Like Article
Like
Save
Share
Report

Excel is a powerful data visualization and data management tool that can be used to store, analyze, and create reports on large data. It can be used to plot different kinds of graphs like line graphs, bar graphs, etc. \

The line graph is also known as a line plot or a line chart. In this graph, lines are used to connect individual data points. It displays quantitative values over a specified time interval. We can easily plot multiple lines on the same graph in Excel by simply selecting several rows (or columns) and creating a line plot.

How to Plot Multiple Lines on an Excel Graph?

How to Plot Multiple Lines on an Excel Graph?

Plotting Multiple Lines on an Excel Graph

1. When the data is arranged in columns

For demonstration, we will use the sales data of three products over the period of different years.

Database column wise

Step 1: Select the cell containing product data.

Selecting product data

Step 2: Select “Insert” Tab from the top ribbon and select the line chart.

Selecting line chart

Output:

Output

2. When the data is arranged in rows

For the purpose of demonstration, we will use the sales data of three products over the period of different years.

Database row wise

Step 1: Select the cell containing product data.

Selecting product data

Step 2: Select the “Insert” Tab from the top ribbon and select the line chart.

Selecting line chart

Output:

Output

Conclusion

In Summary, learning how to plot multiple lines on an Excel graph opens up a world of possibilities for visualizing your data effectively. We have learned to plot multiple lines on a Graph when the data is arranged in columns as well as in rows. As you apply these techniques, you’ll enhance your ability to create clear, compelling graphs that convey valuable insights.

How to Plot Multiple Lines on an Excel Graph – FAQs

How to plot multiple lines in one graph in Excel?

To plot multiple lines in one graph in Excel, follow these steps:

  • Select your data.
  • Go to the “Insert” tab.
  • Click on “Line Chart.”
  • Excel will create a basic line chart with one line.
  • Rightclick on the chart, and select “Select Data.”
  • Click “Add” to add additional data series.
  • Select the range for the new data series.
  • Click “OK” to close the dialog box.
  • Format the chart as needed to distinguish between lines.
  • Your graph now displays multiple lines representing different data sets.

How do I label multiple lines on an Excel graph?

You can label multiple lines by adding a chart title and axis labels. Additionally, you can insert a legend to identify each line by name.

Can I change the order of the lines on an Excel graph?

Yes, you can rearrange the order of the lines by adjusting the order of the data series in the “Select Data” dialog box.


Like Article
Suggest improvement
Share your thoughts in the comments

Similar Reads