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.
Step 1: Select the cell containing product data.
Step 2: Select “Insert” Tab from the top ribbon and select the line chart.
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.
Step 1: Select the cell containing product data.
Step 2: Select the “Insert” Tab from the top ribbon and select the line chart.
Output:
How to Plot Multiple Lines on an Excel Graph?
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.
Contact Us