Basic Excel Line Chart: Create and Format One

To make a basic line chart in Microsoft Excel for Microsoft 365 on Windows, arrange time periods in the first column and the values you want to compare in the columns beside them, select the data, then choose Insert > Insert Line or Area Chart > 2-D Line. Excel creates a chart with time along the horizontal axis and a separate line for each value series.

What a Basic Line Chart Shows

A line chart displays values as points connected in sequence. It is most useful when the order of the observations matters, especially for showing how something changes over time: monthly sales, daily temperatures, yearly membership, or a project’s weekly progress. The line makes rises, falls, turning points, and broad patterns easier to see than a table of numbers alone.

In a standard Excel line chart, the horizontal axis is a category axis. Excel places the labels in their listed order; it does not necessarily space them according to the actual time elapsed between dates. The vertical axis represents numeric values. Each data series gets its own line, and its name usually comes from the column heading.

A line chart is not automatically a forecast or an explanation of why values changed. It summarizes the values supplied. A sharp rise may be real, a data-entry error, or the result of a change in measurement; the chart cannot determine which. Keep the source table available so readers can check the underlying numbers.

Arrange the Data Before Creating the Chart

Clear table structure helps Excel identify the chart’s labels and series. Put one category or date per row, put each series in a separate column, and use a heading at the top of every series column. For example, a small monthly sales table might have Month in A1, North in B1, and South in C1; rows 2 through 13 would contain the months and the two regions’ sales figures.

Use one row for each time period, with no blank rows splitting the data.
Put dates or category labels in the first column and numeric measurements in the next columns.
Give each series a short, meaningful heading. Excel can use these headings in the legend.
Keep units consistent within a series. Do not mix dollars and percentages in one column.
Avoid merged cells and decorative title rows inside the selected table. They can make automatic chart detection less reliable.

Excel can chart dates stored as actual date values, but dates imported from another system may be text instead. Text dates can still appear as labels, yet they may not behave like dates for axis formatting. If the data looks out of order or the labels do not format as expected, check the underlying cells and convert text dates into real Excel dates before charting.

Create the Chart in Excel for Microsoft 365

Select the full table, including its headings. For the example, select A1:C13. Including the headings helps Excel assign the series names and category labels.
On the ribbon, choose Insert > Insert Line or Area Chart, then choose a 2-D Line option. The basic Line option is a useful starting point; Line with Markers adds a visible symbol at each observation.
Check that the chart includes all the expected dates and series. Excel normally places the chart on the current worksheet, where you can move or resize it.
Click the chart title and replace the placeholder with a specific description, such as Monthly Sales by Region. If the chart title is not displayed, use Chart Design > Add Chart Element > Chart Title.

When the data is in a simple contiguous table, Excel often guesses the intended layout correctly. If it does not, select the chart and use Chart Design > Select Data to review the chart data range, series, and horizontal axis labels. Use Chart Design > Switch Row/Column if Excel has treated rows as series when you intended columns to be series, or the reverse. The exact chart tools appear when the chart is selected.

In Excel for Mac, the ribbon’s Insert chart controls and chart-design options provide similar choices, though the interface may be arranged differently from Windows. Excel for the web also supports creating and editing charts, but some formatting controls and chart options can differ from the desktop application.

Read the Lines, Legend, and Axes

Each line represents a series, such as a region, product, or measured quantity. The legend maps each line’s appearance to its series name. If a chart contains several lines, use clear headings and make sure the legend is visible; otherwise, readers may not know what they are comparing. For only one series, a legend is often unnecessary.

The horizontal axis labels identify the categories or time periods. The vertical axis communicates the scale of the values. Excel usually chooses a scale automatically, including minimum and maximum bounds and tick spacing. The default is convenient, but inspect it: a vertical axis that starts well above zero can make modest changes look dramatic. Starting at zero is not mandatory for every line chart, but a truncated scale should be intentional and easy to notice.

When periods are missing, consider whether the chart should show a gap or connect the values on either side. Select the chart, then use Chart Design > Select Data > Hidden and Empty Cells to review how empty cells are displayed. The available choices can vary with chart type and Excel version. Do not replace missing observations with zero unless zero is the true value; doing so changes the meaning of the data.

Format for Clarity

Formatting should make the data easier to read, not compete with it. Start with the chart title and axis titles where units or context are not obvious. To add an axis title, select the chart and choose Chart Design > Add Chart Element > Axis Titles, then edit the text that appears. For example, a vertical title of Revenue (USD) makes the measurement clearer than Revenue alone.

Use a modest number of lines and choose distinguishable colors. Avoid relying on color alone if the chart will be printed in grayscale or viewed by people with color-vision differences.
Use markers when individual observations matter, particularly for short series. With many closely spaced observations, markers can clutter the chart; a plain line may be easier to read.
Keep gridlines light and limited to those that help readers estimate values. A heavy grid can overwhelm the series.
Make labels and lines large enough to read at the chart’s final display size. Resizing a chart smaller can make its text difficult to interpret.

To change a line’s color or thickness, select the line and use the formatting controls on the Format tab or the Format Data Series pane. To change the vertical scale, right-click the vertical axis and choose Format Axis, then adjust bounds or units in Axis Options. If you set fixed bounds, revisit them when the data changes: a fixed maximum can hide newly higher values, while a fixed minimum can conceal lower ones.

Choose the Right Line Chart Type

For a straightforward comparison over time, a standard 2-D Line chart is usually the clearest choice. Line with Markers emphasizes each observation. A 100% stacked line chart shows each series as a share of the total at each category, which is useful for composition but hides the original absolute values. A stacked line chart adds series cumulatively, so it can be hard to judge the movement of any series other than the bottom one. Use stacked variants only when that cumulative or percentage question is what you mean to show.

A line chart is also different from an XY (Scatter) chart. A line chart treats its horizontal entries as ordered categories, with equal visual spacing between adjacent categories. An XY chart uses numeric x-values and spaces points according to their actual numeric distance. Use a scatter chart when the horizontal variable is a measured number, such as elapsed time in minutes with irregular gaps, or when the relationship between two numeric variables is the point. A line chart is usually more natural for monthly periods or a sequence of named stages.

For instance, monthly sales from January through June fit a line chart because the months form a regular sequence. Readings taken after 1, 2, 10, and 30 minutes may be better represented by an XY chart: a category line chart would give the large gaps the same width as the small ones.

Common Problems and Practical Fixes

If Excel displays one line where you expected several, or makes each row a separate line, first check the selected range and headings. Then try Chart Design > Switch Row/Column. Use Chart Design > Select Data to remove an unintended series, add a missing one, or correct the horizontal labels. A series should refer to its numeric values, and the category labels should refer to the corresponding dates or names.

If dates appear as numbers, unfamiliar labels, or an unexpected sequence, inspect the source cells and the horizontal axis settings. The cells may contain text rather than dates, or Excel may be interpreting the axis differently than intended. Right-click the horizontal axis and choose Format Axis to review its options. For a category-style sequence, a Text axis can preserve each label as a category; a Date axis uses date spacing and may handle calendar intervals differently.

If the line has a sudden spike or drop, check the source values before changing the chart scale. A misplaced decimal, a blank entered as zero, an incorrect unit, or a genuine exceptional result can all create a sharp change. If one series is measured in a very different range from another, the smaller series may appear almost flat. A secondary axis is possible through chart formatting, but it can make comparisons misleading because the two scales differ. Consider separate charts or a carefully labeled alternative before adding one.

If the chart does not update after new rows are added, check whether the new data is within the chart’s source range. Converting the source range to an Excel table with Insert > Table can help a chart include subsequently added rows in many ordinary table-based workflows. Confirm the chart range after adding data, especially when the workbook uses unusual layouts or manually set ranges.

Frequently Asked Questions

How do I add a second line to an Excel chart?
Select the chart, choose Chart Design > Select Data, and use Add under Legend Entries (Series) to define the series name and values. If both series already sit in adjacent columns in the source table, selecting the expanded table or correcting the chart data range may be simpler.

Can I make a line chart without markers?
Yes. Choose the basic 2-D Line option rather than Line with Markers, or select an existing series and set its marker options to None in the Format Data Series pane. A line without markers is often cleaner when there are many data points close together.

Why is Excel showing dates as categories rather than spacing them by time?
A standard line chart uses a category axis, which generally spaces labels evenly in their listed order. If actual numeric spacing matters, use an XY (Scatter) chart and set the time values as the x-values. For calendar dates with regular intervals, a line chart is commonly appropriate.

Should a line chart’s vertical axis start at zero?
Not in every case. A zero baseline can make magnitude comparisons easier, while a narrower range can reveal small changes. If you use a nonzero minimum, make that choice visible and interpret the apparent steepness carefully; the scale changes how dramatic the line looks.

How do I show missing values as gaps?
Use Chart Design > Select Data > Hidden and Empty Cells and review the empty-cell display options. Choose a gap when connecting across missing observations would imply data that was never measured. Do not treat a missing value as zero unless zero is accurate.

Check the Chart Before Sharing

Before copying a chart into a report or presentation, confirm that the title says what is being measured, the axes identify categories and units, every line can be matched to a series, and the scale does not obscure the story. Check that all dates are in the intended order and that missing values, unusual spikes, and fixed axis bounds are handled honestly. A basic line chart works best when its visual simplicity is supported by accurate, well-labeled source data.

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.