Site icon Best Excel Tutorial

How to Plot a Line Graph in Excel

In this lesson, you can learn how to plot line chart in Excel.

You can use a line chart to show changes in trends over the time. In this case, we focus on sales.

Prepare Data

Prepare the necessary data in the table.

Ensure your sales data is neatly arranged in a table format, ready for charting.

Select Data

First, select the sales data in 4th, 5th and 6th row.

Insert Line Chart

Go to the ribbon. Here you find the Insert tab. Click the button Line to plot Line Graph.

From the drop-down menu select the first of the charts (2-D Line Chart).

Improve the Chart

Customize the chart by adding a title.

You can do this by going to the “Layout” tab and clicking on “Chart Title” to enter a title for your chart.

Modify Axis Labels

Right-click on the data series in the chart and select “Select Data”.

In the dialog box that appears, edit the horizontal axis labels. Then choose the range axis labels. Select the year from the table data. The data series in the chart now looks as it should.

Finalize and Customize

You can further customize the chart by changing colors, adding data labels, adjusting gridlines, and more to make it visually appealing and informative.

Download free spreadsheet here

Exit mobile version