Excel Smooth Line Chart: How to Create and Format One

To create a smooth line chart in Excel for Microsoft 365 on Windows, select your data, choose Insert > Insert Line or Area Chart > 2-D Line > Line with Smooth Lines, and then adjust the series formatting if needed. The curved line changes how Excel displays the points; it does not smooth, average, or change the values in your worksheet.

Create a Smooth Line Chart

Start with a table that has one column of labels or x-values and one or more columns of measurements. For example, put months in A2:A7 and monthly readings in B2:B7, with headings in row 1. Select the full table, including its headings, so Excel can use the first column for the horizontal axis and the headings for the series names.

Open the Insert tab.
Select Insert Line or Area Chart in the Charts group.
Under 2-D Line, choose Line with Smooth Lines. Choose Line with Smooth Lines and Markers if you also want a visible symbol at each source value.
Use the Chart Design and Format tabs to add a title, change the layout, or adjust the chart’s appearance.

If you already have a line chart, select it and choose Chart Design > Change Chart Type. Select Line, then choose Line with Smooth Lines or Line with Smooth Lines and Markers. This changes the chart type without requiring you to rebuild the source table.

You can also select an individual series, open Format Data Series, and find the Smoothed line option under Fill and Line > Line. This option is useful when you want to keep the existing chart type or change just one series. The precise pane arrangement can vary slightly with the Excel update, but the setting belongs to the selected data series, not to the worksheet cells.

Prepare the Data Before Charting

A good-looking curve starts with a well-structured table. Put each x-axis value in its own row, keep each measurement series in a separate column, and use a clear heading for every column. Avoid blank rows inside the range and merged cells in the data table; both can make Excel guess the chart layout incorrectly. If the chart plots the months as separate series instead of categories, select Chart Design > Switch Row/Column.

Check that values are stored as numbers and dates, not text that merely looks numeric. Dates entered as text may appear in an unexpected order or be treated as ordinary category labels. Sort the rows in the order you want to show. A line chart connects points in the order they appear in the source range; it does not automatically sort dates or measurements for you.

Consider missing observations, too. A blank cell can create a break in the line, or Excel may display it according to the chart’s hidden-and-empty-cell settings. Don’t replace missing data with zero unless zero is the real observation: doing so creates a genuine plotted point at the bottom of the chart and can radically alter the apparent trend.

What the Smooth Setting Actually Does

A standard line chart draws straight segments between plotted observations. A smooth-line chart draws a curved path through or around those positions to make the series look less angular. Excel still plots the same source values, and selecting a point still relates it to its data value. The curve is a visual rendering choice, not a statistical smoothing method such as a moving average.

That distinction matters because a curve can suggest gradual change between observations even when no measurements were collected in between. Depending on the values and spacing, a curved line can also rise above or dip below the neighboring points. The actual measured data has not changed, but a reader may interpret the extra shape as evidence of a peak, dip, or acceleration. Use markers or data labels when readers need to identify the measured observations rather than infer detail from the curve.

For instance, imagine monthly readings of 10, 11, 19, and 20. A smooth curve may make the jump from 11 to 19 appear gradual, but the table only establishes the values at the four recorded months. It does not prove what happened between them. A straight-line chart is often the more conservative choice when the number and timing of observations are limited.

Choose Between a Line Chart and an XY Scatter Chart

A regular line chart treats the horizontal axis as categories. Even if the labels are dates, each category typically receives equal spacing. This is suitable for values collected at consistent intervals, such as one reading every month. It can be misleading when gaps between observations vary: January and February may be placed as far apart as February and June.

An XY scatter chart uses numeric x-values and positions points according to their actual numeric spacing. Choose it when the horizontal values are measurements, elapsed time, or dates with irregular intervals. In the Insert tab, use Insert Scatter (X, Y) or Bubble Chart and choose a scatter subtype with smooth lines, with or without markers. A scatter chart is also useful when you want Excel to treat both axes as numeric scales.

For example, if a sensor recorded a reading after 1, 2, and 10 hours, an XY scatter chart shows the much longer gap between the second and third readings. A category line chart spaces those three observations evenly. Before choosing a chart, ask whether equal spacing represents the real sampling schedule. That decision is more important than whether the connecting line is curved or straight.

Format the Curve for Readability

Curved lines can make a chart feel less jagged, but clarity depends on the number of series, the point density, and the contrast. A few practical choices help the chart remain readable:

Use markers when the individual observations matter, especially for a small data set. For a dense series, markers may overlap and create visual clutter.
Choose distinct, colorblind-conscious colors for multiple series, and don’t rely on color alone if the chart will be printed in grayscale.
Use a concise chart title and descriptive axis titles when the units or subject are not obvious.
Keep gridlines light enough that they support value reading without competing with the data.
Make sure the vertical axis scale does not exaggerate a small difference. A truncated axis can be appropriate for some focused comparisons, but it should be clear and should not create a false impression of magnitude.

For precise formatting, click the line to select its series, right-click it, and choose Format Data Series. In the pane, use Fill and Line to change the line color, width, dash style, or Smoothed line setting. Selecting a marker rather than the line may open formatting controls for the data point or marker, so confirm that the pane heading identifies the series when you mean to change the full line.

Common Problems and Their Fixes

If Excel creates a chart but the curve does not look right, check the data range and chart type before changing colors or line width. These are common causes:

The wrong data is plotted: Select the chart and use Chart Design > Select Data to review the chart data range, series names, and category labels.
The horizontal order is wrong: Sort the source rows into the intended order. For numeric x-values or uneven time intervals, switch to an XY scatter chart.
The chart has an unwanted gap: Check whether the source contains blanks or errors. Select Chart Design > Select Data > Hidden and Empty Cells to review how empty cells are displayed; available choices depend on chart type.
The curve looks exaggerated: Turn off smoothing, show markers, or use a straight-line chart. A curve can imply behavior between sparse observations that the data cannot establish.
The option is missing: Confirm that the selected object is a data series and that you are using a line or compatible scatter subtype. If the editing controls are limited in Excel for the web, open the workbook in the desktop Excel app.

Also check whether Excel interpreted the first row or column as labels. If the chart has a generic series name or repeated labels on the axis, use Select Data to correct the series and category ranges rather than manually editing each chart label.

When a Smooth Line Is a Good Choice

Smooth lines can suit a chart intended to communicate a broad, continuous pattern, such as a sequence of regularly spaced readings that changes gradually. They can also make a simple chart easier to scan when straight segments create a strongly angular appearance. The choice is mainly about presentation, not a guarantee that the underlying process is continuous.

Prefer straight lines when you want to emphasize the exact path between observed points, when data is sparse, or when sharp changes are meaningful. If the goal is to reduce short-term variation and reveal a trend, use a method that actually calculates a smoothed series, such as a moving average, rather than assuming the Smoothed line checkbox does that work. In Excel, a moving-average trendline is a separate chart feature: select a data series, use Chart Design > Add Chart Element > Trendline > More Trendline Options, and choose Moving Average when that option is available for the chart. It adds a calculated trendline; it does not overwrite the original readings.

For a report, consider showing the raw observations with markers alongside any calculated trend. Label the trendline or explain its method so readers can distinguish measured values from a derived summary. In scientific, operational, or financial reporting, that distinction helps prevent a visually polished curve from being mistaken for extra evidence.

Excel on Mac and Excel for the Web

In current Microsoft 365 desktop Excel for Mac, the same broad approach applies: select the data, insert a line chart, and choose the smooth-line subtype. Ribbon placement and the Format Data Series pane can differ from Windows, so use the chart-type gallery or the series-format pane rather than relying on a Windows-only screen location. Keyboard shortcuts are not needed for these chart steps.

Excel for the web supports common chart creation and editing, but some chart formatting controls may not be available in the same place or with the same range as in the desktop app. If you cannot find the smooth-line chart subtype or the Smoothed line control, open the workbook in the desktop version of Excel. The chart remains linked to its source data when you edit it there, provided you save the workbook.

Frequently Asked Questions

Does a smooth line chart change the numbers in Excel?
No. It changes how the line between observations is drawn, not the cell values. To calculate a smoothed set of values, use a separate calculation such as a moving average and chart that new series.

Can I make only one series smooth?
Yes. Select that series, open Format Data Series, and turn on Smoothed line under Fill and Line > Line. Other series can retain straight lines, although mixing styles is most useful when the distinction has a clear meaning.

How do I make an existing Excel line chart smooth?
Select the chart and choose Chart Design > Change Chart Type > Line, then choose Line with Smooth Lines. Alternatively, select the series and use its Smoothed line formatting option if it is available for that chart.

Should I use a smooth line or a scatter chart?
Use a line chart for evenly spaced categories such as monthly periods. Use XY scatter when both axes are numeric or when observations occur at uneven intervals. Either type can offer a smooth-line appearance, but only scatter positions x-values according to their numeric spacing.

Why does my smooth line appear to go beyond a data point?
Curved interpolation can create a visual bulge between observations. It does not mean Excel has added a measured value there. Turn off smoothing or show markers if that shape could be mistaken for a real peak or dip.

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.