How to Make a Line Graph in Excel: Step by Step With Multiple Lines and Trendline

shape
shape
shape
shape
shape
shape
shape
shape
How to Make a Line Graph in Excel: Step by Step With Multiple Lines and Trendline - featured image

A line graph connects data points with a line, so it shows how a value changes over time. It is the best choice for trends, such as monthly sales, website visitors, temperature or the price of a share. Excel can draw one in a few clicks, and with a little formatting it looks clean enough for a report or a presentation. This guide shows how to prepare the data, insert the chart, add a title and axis labels, plot more than one line, change the markers and colors, add a trendline, fix problems with dates and copy the chart into another document. A small monthly sales example with numbers you can check is used throughout.

Updated November 2026

In this guide

  1. When to use a line graph
  2. Example data
  3. Step 1: prepare the data
  4. Step 2: insert the line chart
  5. Step 3: add a title and axis titles
  6. Step 4: show more than one line
  7. Step 5: change colors, lines and markers
  8. Step 6: label the lines instead of a legend
  9. Step 7: add a trendline
  10. Step 8: fix the axis scale
  11. Fix date axis problems
  12. Copy the chart to Word or PowerPoint
  13. Common mistakes
  14. Practice problems
  15. Quick recap

When to use a line graph

Use a line graph when the horizontal axis shows time or an ordered sequence, such as days, months or years, and you want to show the direction of change. Use a bar chart to compare separate categories, such as sales by region, and a pie chart to show parts of a whole. A line graph works well with many points, because the line keeps the picture simple. It is less suitable for a handful of unrelated categories, where the line would suggest a link that does not exist.

Example data

Use six months of sales. Put the months in A2:A7: January, February, March, April, May and June. Put the sales for the first product in B2:B7: 120, 135, 150, 145, 170 and 190. Put the sales for the second product in C2:C7: 100, 110, 105, 130, 125 and 140. The headers are Month, Product A and Product B in row 1. The total for Product A is 910 and the total for Product B is 710. Product A rises from 120 to 190, which is an increase of 70, or about 58 percent.

Step 1: prepare the data

Arrange the data in columns, with the categories in the first column and each series in its own column, and with a header on top of each. Remove blank rows and columns inside the data, since gaps can break the line. Make sure the numbers are real numbers and not text. If you plan to add data later, convert the range to a table with Ctrl+T, so the chart grows automatically. Our table guide explains how this works.

Step 2: insert the line chart

Select A1:B7 for one line, or A1:C7 for two lines. Go to the Insert tab, open the Line or Area chart menu in the Charts group and choose Line with Markers, or plain Line. Excel inserts the chart next to the data. You can also use Recommended Charts, which suggests a line chart for time series. The chart appears with a title, a legend and gridlines. Drag it to the place you like, and resize it by dragging the corners. A wide chart is better for a time series than a square one.

Step 3: add a title and axis titles

Click the chart, then click the plus icon at the top right, which is Chart Elements. Tick Chart Title and Axis Titles. Click each title and type your text. A good chart title says what the reader sees, such as Monthly sales by product, January to June. The vertical axis title should state the unit, such as Sales in units, and the horizontal axis can say Month. Clear titles save the reader from guessing, which is important when the chart is shared without explanation.

Step 4: show more than one line

If you selected A1:C7, the chart already has two lines, with a legend that names them. To add another series later, right-click the chart, choose Select Data, click Add and select the name and the values. To remove a series, select it and click Remove. When the series have very different sizes, such as units and revenue, one line can look flat. In that case, put one series on a secondary axis: right-click the line, choose Format Data Series and select Secondary Axis. Use this carefully, because two scales can mislead.

Step 5: change colors, lines and markers

Click a line to select the series, then right-click and choose Format Data Series. In the Fill and Line section, choose the color, the width and the dash type of the line. Under Marker, choose the shape, size and fill. A width of 2.25 points and round markers of size 7 are good for most charts. Use strong, different colors for the lines, and use a dashed line for a forecast. For a clean look, remove the chart border and light grey gridlines, so the lines stand out.

Step 6: label the lines instead of a legend

A legend forces the reader to look away from the line. A cleaner option is to label the line directly. Click the last point of a line, add a data label and show only the series name. Then delete the legend. For two lines, this reads naturally. Do not add a label to every point, because it clutters the chart. Instead, label only the last point or the highest point, such as 190 for Product A in June, to make the key message clear.

Step 7: add a trendline

A trendline shows the general direction of the data. Click the line, choose the plus icon, tick Trendline and pick Linear. For Product A, the trendline rises, and the slope is about 12.9 units per month. You can show the equation and R squared in the Format Trendline pane. A linear trendline is a good first choice for steady growth. For curved patterns, try a polynomial or exponential type, but be careful not to overfit. Our sales forecast guide shows how to use the trend for predictions.

Step 8: fix the axis scale

Excel chooses the scale of the vertical axis automatically. It often starts at a value above zero, which makes small changes look big. Double-click the vertical axis and set the minimum and the maximum. For our data, a minimum of 0 and a maximum of 200 show the real size of the changes. A truncated axis is acceptable for line graphs if it is clear, but a zero baseline is more honest for sales. Also set the major unit, such as 50, for clean gridlines.

Fix date axis problems

If the horizontal axis has real dates, Excel may treat it as a date axis and space the points by the number of days between them. That is correct for uneven dates, but it can look odd for monthly data, since months have different lengths. Right-click the horizontal axis, choose Format Axis and set Axis Type to Text axis, to place the points at equal distances. If the dates appear as numbers like 46023, format the cells as dates. If the chart shows every day while you only have months, set the base unit to Months.

Copy the chart to Word or PowerPoint

Click the chart, press Ctrl+C, and paste it into Word or PowerPoint. Choose Keep Source Formatting and Link Data if the chart should update when the Excel file changes, or Picture if the reader should not edit it. A picture is safer for emails and reports. To reuse the style in other workbooks, right-click the chart and choose Save as Template, then pick it from the Templates folder in Insert Chart. Saving a template gives you the same look for every report.

Common mistakes

The most common mistake is to use a line graph for unordered categories. Another is to include the header or the total row in the selection, so the line has an odd point. A third is to leave blank cells, which can show gaps or drop to zero, depending on the settings. Fix this in Select Data, Hidden and Empty Cells. A fourth is to use too many lines, which becomes a tangle. Keep it to five or fewer. A fifth is to leave out the units. A sixth is to use a 3D style, which distorts the values.

Practice problems

Try these. Problem 1: build the chart for Product A and read the value in April, which is 145. Problem 2: add Product B and see in which month the gap is the widest, which is June, with a gap of 50, since 190 minus 140 is 50. Problem 3: add a linear trendline to Product A. Problem 4: change the vertical axis to start at 0 and end at 200. Problem 5: add a title and axis titles, and label the last point of each line.

Quick recap

Arrange the data with the dates or categories in the first column and each series in its own column. Select the data and choose Insert, Line chart. Add a title and axis titles, format the lines and markers, label the lines directly and set a sensible axis scale. Add a trendline if the direction matters. Use a text axis for monthly data and save the chart as a template for reuse. A simple, clear line graph shows a trend better than any table of numbers.

Frequently asked questions

How do I make a line graph in Excel?

Select your data and choose Insert, then Line chart.

How do I add a second line to a graph?

Include the second column in the selection or use Select Data, Add.

How do I add a trendline?

Click the line, use Chart Elements and tick Trendline.

Why does my line graph show gaps?

There are blank cells, so check Hidden and Empty Cells in Select Data.

When should I use a line graph?

Use it to show changes over time.

Related guides and free tools

Leave a Reply

Your email address will not be published. Required fields are marked *