Excel Line Chart Smooth Curve: Setup, Limits, and Tips

Yes. In Excel for Microsoft 365 on Windows, select a line in the chart, open Format Data Series, then choose Fill & Line > Line > Smoothed line. This changes how Excel draws the line between existing points; it does not smooth, alter, or add values to the worksheet data.

Turn on a smooth curve in Excel

Use these steps for an existing line chart:

Click the chart, then click the data series whose line you want to curve. If the first click selects the whole chart, click the line again. You should see selection handles on the series or its points.
Right-click the selected series and choose Format Data Series. The formatting pane opens at the side of the window.
In the pane, choose Fill & Line, shown with a paint-bucket icon, and expand Line.
Check Smoothed line. Repeat for any other series you want to smooth.

To turn the effect off, return to the same setting and clear the checkbox. If you are formatting a scatter chart, select its data series and look for the same line setting. On Excel for Mac, select or Control-click the series, open Format Data Series, and look under Fill & Line > Line; the pane layout can differ slightly by release. Excel for the web does not expose every desktop chart-formatting option. If you cannot find the checkbox there, open the workbook in the desktop app.

What the smooth-line setting actually does

A regular line chart connects one plotted point to the next with straight segments. A smoothed line draws a curved path through or around those points to make the series look less angular. The curve is a visual treatment of the chart, not a calculation applied to the cells. The underlying values, formulas, and chart data range remain unchanged.

This distinction matters when interpreting a graph. Suppose monthly sales are 20, 35, 24, and 41. A smooth curve may look as though sales rose gradually, fell, then climbed in a continuous way. The worksheet still contains only four monthly observations. The curve does not tell you what sales were on the days between those observations, nor does it establish that a real-world trend followed that precise path.

Curved lines can also make a series look as if it peaks, dips, or extends beyond the value at a nearby data point. Treat those visual bends as styling, not additional evidence. For a report where readers need to compare exact values, visible markers and data labels can help keep the actual observations clear.

When a curved line is a good choice

Smoothing can be useful when the goal is a polished overview and the data show a gradual progression. For example, a presentation chart of average monthly temperatures may be easier to scan with a gentle curve than with sharp corners at every month. It can also work for a small number of measured points where the curved treatment does not imply more precision than the measurements support.

Prefer straight segments when the exact movement between observations matters, when a series has abrupt changes, or when the data are categorical rather than continuous. A curved path can soften a sudden drop or make a brief spike appear less important. In operational charts, quality-control reporting, and other settings where a reader must see a threshold crossing or a sudden change, straight segments are often the clearer choice.

Before using the effect, consider:

What each point represents: A monthly total is a discrete observation, while frequent measurements of a physical process may reasonably be shown as a continuous path.
How many points there are: A few points can make a smooth curve look more certain than the evidence warrants.
Whether values change sharply: Smoothing may visually soften peaks, valleys, or sudden reversals.
Who will read the chart: If the audience needs to recover exact values, include markers, labels, or a nearby data table.

Line charts versus scatter charts

An Excel line chart is designed to show values across categories, often months, product names, or stages. Its horizontal axis typically treats each category as a position in a sequence. If dates are being treated as categories, February can appear the same horizontal distance from January as March does, even if the actual gaps between observations are unequal.

A scatter chart uses numeric x-values and places points according to their numerical distance. Choose one when the horizontal values are measurements, elapsed times, or dates with irregular intervals and those intervals matter. For example, readings taken after 1, 2, and 10 hours should not necessarily be spaced as if they were taken at equal intervals. A scatter chart can show the spacing implied by those x-values.

To make one, select the x- and y-value columns, then use Insert > Insert Scatter (X, Y) or Bubble Chart and choose a scatter subtype such as Scatter with Smooth Lines or Scatter with Smooth Lines and Markers. The available subtype names depend on the chart gallery and selection. A scatter chart with smooth lines is not the same thing as statistically smoothing the data: it still draws a path between the plotted observations.

Create a line chart with smooth lines

If you have not made the chart yet, put categories in one column and the corresponding values in the next, select the range, and choose Insert > Insert Line or Area Chart. Pick a line-chart subtype, such as a line with markers, then apply the Smoothed line setting to the series as described above. Starting with a standard line chart and enabling the setting gives you control over whether markers appear; choosing a chart subtype with smooth lines is another route for scatter data.

With multiple series, format each one separately. For instance, a chart comparing actual and target values may benefit from smoothing one series but not the other, depending on what the lines represent. Check the legend and colors after formatting so readers can still identify each series. If Excel selects the wrong line, click the intended series again or use the chart’s selection controls before opening the formatting pane.

Markers are useful when the curve passes through a limited number of observations. To show or hide them, format the series and open the Marker settings in the pane, or choose a chart style that includes markers. A chart with both a curve and markers communicates that the drawn path is a visual connection while the markers identify the recorded points.

Common problems and practical fixes

You cannot find Smoothed line: Make sure a data series—not the chart area, plot area, or an individual chart title—is selected. Expand the Line section in the series pane. If the command is unavailable in the web app, try Excel for Windows or Mac desktop.
Only one line changed: The setting applies to the selected series. Select each additional series and enable it separately.
The curve looks misleading: Turn smoothing off, add markers, or use a straight-line chart. If the purpose is to summarize noisy measurements, use a clearly labeled statistical approach rather than treating a cosmetic curve as analysis.
Points appear in an unexpected order: Check the source-data order and the category labels. A line chart connects points in the chart’s sequence; it does not automatically sort categories into a meaningful chronological or numerical order.
There are gaps in the data: Review the chart’s empty-cell settings if missing values affect the display. A smoothed line does not supply genuine missing observations, and connecting across a gap may imply continuity that the source does not establish.

For dates or numbers on the horizontal axis, also confirm whether a line chart or scatter chart better represents the data. Switching chart type can fix spacing problems that smoothing cannot.

Alternatives when you mean data smoothing

People sometimes ask for a smooth curve because they want to reduce fluctuations in the measurements, not merely round the chart’s corners. Those are different jobs. The Smoothed line checkbox changes the rendering. It does not calculate a moving average, remove noise, fit a trend, or change the values being plotted.

If the goal is to show a general trend, consider adding a trendline from Chart Design > Add Chart Element > Trendline, then choose a suitable type. A moving average trendline, where available for the chart, summarizes variation over a chosen number of points; its period affects how responsive or gradual it looks. A trendline is a separate analytical chart element, so label it and explain its meaning rather than presenting it as the original series.

Another option is to calculate a separate smoothed data series in the worksheet using a method appropriate to the context, then plot both the original and calculated series. That makes the transformation visible and auditable. Do not replace original measurements without keeping them, and do not use a smoothing method merely because the resulting line looks attractive. The right choice depends on what the data represent and what readers need to infer.

Frequently Asked Questions

Can Excel make a line chart curve instead of using straight lines?

Yes. Select the series and enable Format Data Series > Fill & Line > Line > Smoothed line. The option changes the drawn line, not the worksheet values.

Does a smooth line in Excel change my data?

No. It changes how the chart connects the existing points. It does not calculate intermediate observations or smooth the source cells.

Can I smooth just one series in a chart?

Yes. Select that series and enable Smoothed line. Other series keep their own formatting until you change them.

Why does my smooth curve look like it goes past a data point?

The curved drawing can appear to bulge or dip between observations. That shape is a chart-rendering effect, not a new measured value. Add markers or use straight segments if the distinction could confuse readers.

Should I use a line chart or a smooth scatter chart?

Use a line chart for ordered categories such as months when category spacing is appropriate. Use a scatter chart when numeric x-values and their actual intervals matter; it can also display smooth lines without turning the curve into a statistical analysis.

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.