Line Chart in Excel: Definition and How It Works

A line chart in Excel displays data as points connected by straight lines, making changes and trends across an ordered set of categories—often dates—easy to see. To create one in Microsoft Excel for Microsoft 365 on Windows, select your data, choose Insert > Insert Line or Area Chart, and pick a line-chart style.

What a Line Chart Means in Excel

A line chart is a chart type that plots one or more data series as a sequence of values. Each value appears at a position along the horizontal axis, and Excel connects successive points with lines. The vertical axis shows the values being measured. For example, a table of monthly website visits can become a line chart with months along the bottom and visit counts up the side.

The word “line” describes how Excel displays the values, not a mathematical trend line or a forecast. A standard line chart connects the recorded data points in order; it does not calculate a relationship, fill in missing measurements, or predict future values by itself. You can add a trendline separately when you want a fitted line that summarizes a pattern.

Excel treats the horizontal axis in a line chart as a category axis. Categories might be months, product names, or stages in a process. They are shown in sequence, while the vertical axis is numeric. This makes a line chart useful when the order of categories matters and the goal is to follow movement from one point to the next.

What a Line Chart Helps You See

Line charts are especially useful for showing how a measure changes over time. A single line can reveal a rise, decline, plateau, recurring seasonal pattern, or sudden change. Several lines let you compare related measures across the same periods, such as sales in different regions or daily temperatures from multiple locations.

Consider a table with a Month column and separate columns for Store A and Store B. Excel can plot each store as a series against the same monthly categories. If Store A rises while Store B falls, the direction of the two lines makes the contrast apparent. A clear legend identifies which line belongs to each store.

Line charts are less suited to showing the exact ranking of many unrelated items or the relationship between two independent numeric measurements. A long list of product names may be easier to compare in a bar chart. Measurements such as height and weight, where both axes represent numeric values and the spacing between x-values matters, usually call for an XY scatter chart instead.

Line Chart Types Available in Excel

Excel offers several line-chart variations. The standard 2-D Line chart connects values without placing a visible marker at every point. Line with Markers adds a symbol at each observation, which can help readers identify individual values when there are only a modest number of categories. With a dense series, markers may overlap and make the chart harder to read.

Line: Emphasizes the overall path of each series.
Line with Markers: Shows the path and makes the individual observations visible.
Stacked Line: Places series on top of one another cumulatively, which emphasizes how components contribute to a total but changes how each line should be interpreted.
100% Stacked Line: Displays each series as a share of the total at each category, so the values are expressed as proportions rather than their original magnitudes.

Excel also includes 3-D line-chart options, but three-dimensional styling can make values and crossings more difficult to judge. For most comparisons, a 2-D chart is the clearer choice. Use a stacked version only when its cumulative or percentage meaning matches the question you are trying to answer.

How to Create a Line Chart

For a straightforward chart, arrange the data in a table with category labels in the first column and each series in its own column. Include a header for each series. For example, A1 could contain Month, B1 Store A, and C1 Store B; the rows below would hold each month and the corresponding figures.

Select the complete data range, including the headers and category labels.
On the ribbon, choose Insert > Insert Line or Area Chart.
Under the 2-D Line options, choose the style that fits the data, such as Line or Line with Markers.
Review the resulting chart. Check that the horizontal categories and series are assigned in the intended direction.
Add a descriptive chart title and, where useful, axis titles or a legend.

If Excel puts each month in the legend instead of along the horizontal axis, select the chart and choose Chart Design > Switch Row/Column. You can also use Chart Design > Select Data to inspect or adjust the chart data range, series names, and category labels. These contextual Chart Design commands appear when the chart is selected.

In Excel for Mac, the ribbon-based chart workflow is broadly similar, though the ribbon layout and some dialog details can differ. Excel for the web also supports inserting and editing charts, but available formatting controls may differ from the full desktop application.

Arrange Data for a Useful Chart

The shape of the source table affects how Excel interprets the chart. A typical layout uses one category column and one or more value columns. Headers help Excel name the series, and labels in the first column give the horizontal axis meaningful categories. Avoid blank rows or columns inside the data range, since they can complicate the chart’s interpretation.

Dates should be real Excel date values if you want Excel to recognize them as dates; text that merely looks like a date may not behave the same way. Depending on the axis settings and data, Excel can display a date axis with time-based spacing or a text axis with categories spaced evenly. If weekends or missing dates matter to the story, check the axis behavior rather than assuming every label is being spaced by elapsed time.

For a chart with many series, ask whether every line adds useful information. Too many lines can overlap and conceal the pattern. Consider separating groups into multiple charts, filtering the data, or highlighting only the most important series. If the series have very different magnitudes, a smaller series may look nearly flat; separate charts or an appropriate alternative may communicate the comparison more honestly than adding a second axis without explanation.

Format Axes, Lines, and Labels

A useful chart makes its units and context clear. Give the chart a title that says what is measured and, when relevant, the period covered. Use axis titles when the units are not obvious—for instance, “Month” and “Orders.” Keep the legend close enough to the chart to identify each line, and use direct labels only when they improve clarity rather than crowding the plot.

To add a chart title or axis title in Excel for Windows, select the chart and choose Chart Design > Add Chart Element, then select the relevant title option. For common appearance changes, the Chart Design and Format tabs provide chart styles, colors, and formatting controls. A restrained palette and distinct line colors help readers follow series, including people viewing the chart on a screen with limited color differentiation.

Check the vertical axis scale before drawing conclusions. A vertical axis that starts above zero can make modest changes appear dramatic; that may be suitable for examining small fluctuations, but the choice should be visible and appropriate to the message. Axis bounds and number formats can be adjusted through the axis formatting options. Avoid excessive gridlines, decorative effects, or labels at every point if they distract from the trend.

Line Charts Compared with Other Excel Charts

A line chart and an XY scatter chart can both show points joined by lines, but their horizontal axes mean different things. A line chart uses ordered categories and generally gives each category a position in the sequence. A scatter chart uses numeric x-values and positions points according to their actual values, preserving the distances between them. Use a scatter chart when uneven intervals between numeric measurements are important or when you want to examine how two numeric variables relate.

A column chart is often better when the main task is comparing separate categories, such as revenue by department. A line chart becomes more informative when those categories form a meaningful progression, such as revenue by quarter. For time-series data, a line emphasizes continuity and direction; a column chart can emphasize the size of each discrete period. Neither is automatically correct: choose according to the question and the structure of the data.

A common misconception is that connecting points proves a continuous change between observations. The line is a visual link between measured categories, not evidence that every intermediate value was observed. If monthly readings are missing, for example, the chart should not imply that the missing month was measured. Make gaps and limitations clear, or use an appropriate empty-cell display setting.

Common Line Chart Problems

Categories and series are reversed: Use Chart Design > Switch Row/Column, or review the assignments in Chart Design > Select Data.
The x-axis labels appear out of order: Check the order in the source table. If the labels are dates, verify they are stored as dates rather than text and review the axis type.
Lines appear to jump across missing values: Select the chart and open Chart Design > Select Data, then choose Hidden and Empty Cells. Review the options for displaying empty cells as gaps, zeros, or connected points; select the treatment that accurately represents the data.
One series looks almost flat: Compare its values with the other series. Different scales may make direct visual comparison difficult, so consider separate charts or another clearly labeled presentation.
The chart is cluttered: Reduce the number of displayed series, remove unnecessary markers or labels, and use a concise legend and title.

When diagnosing a chart, compare it with the source table rather than relying only on appearance. A mistaken selected range, an extra total row, or a header treated as a value can create a plausible-looking but misleading result. Correcting the source selection is usually better than trying to disguise the problem with formatting.

Frequently Asked Questions

What is a line chart in Excel?
A line chart is a visual display of one or more data series in which Excel plots values against ordered categories and connects the plotted points. It is commonly used to show trends across time.

When should I use a line chart instead of a scatter chart?
Use a line chart when the horizontal dimension is an ordered set of categories, such as months. Use an XY scatter chart when the x-axis contains numeric values and the actual spacing between those values matters.

How do I add markers to a line chart?
Select the chart, then choose Chart Design > Change Chart Type and select a Line with Markers option. You can also choose that style when first inserting the chart.

Can a line chart show more than one data series?
Yes. Put each series in a separate value column with its own header, select the full table, and insert a line chart. Excel can plot the columns as separate lines and use the headers for the legend.

Why does Excel connect points when a value is missing?
The chart’s empty-cell setting controls whether missing values appear as gaps, as zero values, or as a line connecting surrounding points. Open the chart’s Select Data options and choose the display that best reflects what is actually known.

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.