Excel Line Chart Tutorial: Create and Format One

To make a line chart in Excel for Microsoft 365 on Windows, arrange your categories in one column and each data series in its own column, select the range including headers, then choose Insert > Insert Line or Area Chart and select a 2-D Line option. Excel creates a chart you can refine with the Chart Design and Format tabs.

Prepare the data for a line chart

A line chart works best when the first column contains categories in the order you want them displayed, and adjacent columns contain numeric values. For example, column A might list the months January through June, column B monthly revenue for Store A, and column C monthly revenue for Store B. Put a clear heading at the top of every column.

Keep one observation per row and avoid blank rows or columns inside the range. Check that values are numbers rather than text; numbers imported from another system can sometimes be stored as text and may not plot as expected. Dates should be genuine Excel dates if you want Excel to treat them as dates. The chart can use a category axis even when the labels look like dates, but real dates let you choose a date axis and control its spacing.

Use consistent units within a series, such as dollars throughout rather than dollars mixed with thousands of dollars.
Keep category labels in chronological or meaningful sequence. Excel does not always sort a text list into the order you intend.
Include headers so the chart can use them as legend names.
Do not add a total row to the plotted range unless you intentionally want the total represented as another observation.

Create the chart step by step

Select the complete data range, including the header row and category labels.
Open Insert > Insert Line or Area Chart on the ribbon.
Choose a chart style, such as Line or Line with Markers, from the 2-D Line group.
Click the chart title and type a specific description, such as Monthly Revenue by Store. Use the Chart Design tab to add or reposition chart elements if needed.
Check that the horizontal axis shows the intended categories and the legend names match the series headings.

Excel may suggest a chart type through its Recommended Charts feature, but choosing a line chart directly gives you control over the result. If Excel places the series and categories in the wrong direction, select the chart and choose Chart Design > Switch Row/Column. This is useful when the data is arranged with series in rows rather than columns.

To adjust the source range after creation, select the chart and choose Chart Design > Select Data. The Select Data Source dialog lets you change the chart data range, add or remove series, and edit category labels. This is often quicker and safer than deleting a chart and starting over.

Choose a line chart style

A standard line chart connects each series’ values in category order. Use it when the sequence matters, such as weekly attendance, monthly expenses, or temperature readings taken at regular intervals. Markers are the small symbols at individual observations. They make individual values easier to locate, especially with a short series, but can clutter a chart containing many closely spaced points.

Excel also offers stacked line and 100% stacked line charts. A stacked line chart adds each series to the values below it, so the plotted height represents a cumulative amount rather than the series’ original value. A 100% stacked line chart expresses each category as a proportion of the total. These formats answer questions about composition, not direct comparisons of each series’ original values. Use them only when that cumulative interpretation is appropriate.

A common misconception is that every chart with lines is a line chart. An XY (Scatter) chart is usually more suitable when the horizontal values are numerical measurements with meaningful, uneven spacing, such as elapsed time in minutes or dosage amounts. A line chart treats its horizontal labels as categories, so points may be evenly spaced even if the labels represent dates separated by different intervals.

Format titles, axes, and gridlines

Good formatting helps readers understand the data without changing what the chart says. A useful title identifies the measure and, where relevant, the population or time period. Axis titles can explain units—for example, Revenue (dollars)—when the chart would otherwise leave them unclear. Select the chart and use Chart Design > Add Chart Element to add a chart title, axis titles, gridlines, or a legend. Available choices depend on the selected chart type.

To change an axis, right-click it and choose Format Axis. The formatting pane provides options for labels, number formats, axis bounds, and (for a horizontal category axis) axis type. For date categories, choose a date axis when you want the spacing to reflect calendar time; choose a text axis when every listed category should receive equal spacing. If dates appear in an unexpected order, first check the source data order and whether the cells contain real dates.

Be thoughtful about the vertical axis scale. A line chart with a vertical axis that starts well above zero can make small differences look dramatic. A zero baseline is often appropriate for quantities where the size of the change should be judged against the whole scale, but it is not a universal rule: for some measurements, a zero value is impossible or irrelevant. If you set bounds manually, make the choice clear and avoid implying a larger effect than the values support. Keep gridlines light enough that they do not compete with the data.

Compare multiple series clearly

To compare several groups, put each group in a separate value column with its own heading. Excel will generally create one line per value column and use the headings for the legend. Use distinct, readable colors and make sure the lines remain distinguishable when printed or viewed by people with color-vision differences. Markers, line styles, or direct labels can help when colors alone are not enough.

Before adding more series, ask whether they share a meaningful scale. A series measured in dollars and another measured in percentages can make one line appear flat when plotted on the same vertical axis. Consider separate charts or a clearly explained secondary axis instead of forcing unrelated measures together. A secondary axis can be added through Chart Design > Add Chart Element > Axes, but it can also make comparisons misleading if the scales are not explained. Do not use one merely to make every line look prominent.

If the legend is hard to read, move it, enlarge the chart, or simplify the series names in the source headers. A chart with too many lines is often difficult to interpret even after careful formatting. Splitting it into two charts or filtering to the series relevant to the question can be more useful than adding more visual effects.

Handle missing values and changing data

Blank cells can affect a line in different ways. Select the chart, choose Chart Design > Select Data, and then choose Hidden and Empty Cells in the dialog. For empty cells, Excel can display a gap, treat the empty cell as zero, or connect data points with a line. A gap usually communicates that a value is unavailable; zero should be selected only when the underlying value truly is zero. Connecting across blanks may be reasonable when a continuous trend is intended, but it can hide the fact that observations are missing.

Data added outside the chart’s current source range may not appear automatically. If the source is an Excel table, adding rows directly below the table usually expands the table, and charts based on it can incorporate the new records. If the chart uses an ordinary cell range, use Chart Design > Select Data to expand the range. For recurring reports, converting the source range into a table with Home > Format as Table can make it easier to maintain a growing dataset.

Fix common line chart problems

The chart shows the wrong categories or series: Use Chart Design > Switch Row/Column, then confirm the source range and headers in Select Data.
The horizontal axis is out of order: Sort the source rows into the intended sequence. A line chart follows the source order; it does not automatically infer the correct chronology from text labels.
A line is missing or stops unexpectedly: Check for text-formatted numbers, blanks, hidden rows, and the options under Hidden and Empty Cells.
Dates are evenly spaced when they should not be: Confirm the cells contain actual dates and set the horizontal axis to a date axis when appropriate.
The chart looks crowded: Remove unnecessary series, reduce marker use, simplify labels, or make the chart larger. Avoid shrinking text to fit.
The trend looks exaggerated: Inspect the vertical-axis bounds and explain any nonzero baseline or manually restricted scale.

When troubleshooting, compare the chart with a small sample of the source values. That helps distinguish a formatting issue from a data issue. Also check for filters: filtered or hidden rows may not be plotted depending on the chart’s settings.

Share and maintain a readable chart

Before sharing, verify that the title, units, time period, and series names make sense without extra explanation. A chart copied into a presentation or document may be viewed away from its source worksheet, so it should not depend on nearby cells for context. Use a readable font size and sufficient contrast, and avoid relying on color alone to identify lines.

For a printed report, check the chart in print preview and consider whether thin lines or pale colors will remain visible. If the chart is intended for a screen, test it at the size readers are likely to use. Keep a copy of the underlying data with the workbook when appropriate, and make clear whether values are actual, estimated, or incomplete. Excel for Mac also supports line charts; its ribbon layout and some dialog placement can differ from Windows. Excel for the web supports creating and editing common charts, though some detailed formatting controls may be more limited than in the desktop app.

Frequently Asked Questions

How do I add a line to an existing Excel chart?
Select the chart, choose Chart Design > Select Data, and add a series in the Select Data Source dialog. You can select the series name and value range there. If the new data is next to the existing range, expanding the chart data range may be simpler.

How do I show values on the lines?
Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a position. Labels are useful when there are only a few points. On a crowded chart, they can overlap, so consider labeling only key values or relying on the axis and legend instead.

Can I make an Excel line chart start at zero?
Right-click the vertical axis, choose Format Axis, and enter zero as the minimum bound under Axis Options if that bound is available for the chart. Whether zero is the right choice depends on the data and the point of the comparison; disclose a restricted scale when you use one.

What is the difference between a line chart and a scatter chart?
A line chart places categories in sequence and usually spaces them evenly. An XY (Scatter) chart positions points according to numeric horizontal values, making it better for uneven intervals or examining the relationship between two numeric variables. Choose based on what the horizontal values mean, not just on the fact that both chart types can show lines.

Why does Excel connect across a blank cell?
The chart’s empty-cell setting may be configured to connect data points. Select Chart Design > Select Data > Hidden and Empty Cells and choose a gap if you want missing observations to remain visibly missing. If the cell contains a formula returning an empty string rather than being genuinely blank, check how the chart is interpreting that result as well.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.