How To Make A Line Graph In Excel With Multiple Lines

Excel Line Chart (Tables of Contents)

Line Chart in Excel
How to Create a Line Nautical chart in Excel?

Line Chart in Excel

Line Chart is a graph that shows a serial of point trends connected by the direct line in excel. Line Chart is the graphical presentation format in excel. By Line Nautical chart, nosotros can plot the graph to see the trend, growth of whatever production, etc.

Line Nautical chart can be accessed from theInsert menu under the Chart section in excel.

How to Create a Line Chart in Excel?

It is very simple and easy to create. Let us at present see how to create a Line Chart in Excel with the aid of some examples.

You tin download this Line Nautical chart Excel Template here – Line Chart Excel Template

Case #one

Here we have sales data of some products sold in a random month. Production Blazon is mentioned in cavalcade B, and their sales data are shown in subsequent cavalcade C, as shown in the beneath screenshot.

Allow's create a line chart in the to a higher place-shown data. For this, kickoff, select the information table and so go to the Insert menu; under Charts, select Insert Line Chart as shown below.

Once we click on the Insert Line Nautical chart icon equally shown in the above screenshot, nosotros will get the drib-down menu of different line nautical chart carte du jour available nether it. As we can see below, it has 2D, 3D and more line charts. For learning, choose the first basic line nautical chart every bit shown in the beneath screenshot.

Once we click on the basic Line chart as shown in the above screenshot, we will get the line chart of Quantity sold, drawn equally below.

As we can see, there are some more options bachelor at the right elevation corner of the Excel Line Chart, by which we can practice some more modifications. Let'southward see all the bachelor options i by ane.

Kickoff, click on a cantankerous sign to come across more than options.

Once we do that, we will go Chart Elements, as shown below. Here, nosotros have already checked some of the elements for an explanation.

Axes: These are numbers shown in Y-axis. It represents the range under which data may fall in.
Axis Title: Centrality Championship as information technology is mentioned beside Axes and lesser of product types in the line chart. We can choose/write any text in this title box. It represents the information type.
Chart Title: Chart title is the heading of the whole Chart. Here, it is mentioned as "Quantity Sold."
Data Labels:These are the datum points in the graph, where the line chart points are pointed. Connecting data labels creates line charts in excel. Here, these are 240, 280, 234, and 246.
Data Table: Data Tabular array is the table that has data used in creating a line chart.
Error Bars:This shows the kind of mistake and corporeality of error the data has. These are Standard Error, Standard Divergence, and Percentage mainly.
Gridlines:Horizontal thin lines shown in the above chart are Gridlines. Primary Minor Vertical/Horizontal, Primary Major Vertical/Horizontal is the types of gridlines.
Legends:Different colour lines, different types of the line present unlike data. These are call Legends.
Trendline:This shows the data tendency. Hither information technology is shown by a dotted line.

Now, let's see the Nautical chart Mode, which has the icon as shown in the below screenshot. In one case we click on it, we will get different styles listed and supported for that selected data and the Line Chart. These styles may change if nosotros choose some other chart type.

If we click on the Color tab circled in the beneath screenshot, we will see the different colour patterns used to have more one-line data to show. This makes the chart more attractive.

So we take Chart Filters. This is used to filter the data in the nautical chart itself. We can cull ane or more categories to get the information trend. As we tin select in beneath, we take called laptops and Mobile in the product to get the data trend.

And the aforementioned is getting reflected in Line Chart as well.

Example #two

Permit's see one more example of the Line Charts. Now consider the 2 data sets of a table every bit shown below.

First, select the information table and get to the Insert carte du jour and click on Recommended Charts as shown beneath. This is another method of creating Line Charts in excel.

Once nosotros click on it, we volition get the possible charts that the nowadays selected data tin can make. If the recommended nautical chart does non have the Line Chart, click the All Charts tab below.

Now, from the All Chart tab, select Line Chart. Here as well, we will get the possible type of line chart that may exist created by the current information set in excel. Select one type and click on OK, as shown below.

Later on that, we will go the Line Nautical chart as shown below, which we name every bit Sales Tendency.

We can decorate the data as discussed in the offset example. Also, at that place is more way of selecting different designs and styles. For this, select the chart first. After selection, Design and Format menu tab becomes agile, every bit shown below. From those, select the Pattern card and select under that select and suitable style of chart. Here, we take selected a blackness colour slide to have a classier wait.

Pros of Line Chart in Excel

Information technology gives a great trend projection.
Nosotros can run across the mistake percent every bit well, by which the accurateness of data tin be adamant.

Cons of Line Chart in Excel

It can be used only for trend project, pulse data projections simply.

Things to Recollect Nearly Line Chart in Excel

Line Nautical chart with a combination of Column Nautical chart gives the best view in excel.
Ever enable the information labels so that the counts tin be seen easily. This helps in the presentation a lot.