No: in Excel for Microsoft 365 on Windows, an area chart does not provide a supported Smoothed line setting for its data boundaries. To get a smoothed curve, change the chart to a line chart and apply the setting there; if you need a filled area as well, a combo chart with a duplicate line series may work as a visual workaround.
How area charts represent data
An area chart plots each value at its category or date and joins neighboring points with straight segments. It fills the space between the plotted series and a baseline, usually the horizontal axis. The filled region makes the size of a series visually prominent, which can help show a total or the broad scale of change over time.
That fill is also why an area chart is not simply a line chart with color underneath. In a regular area chart, later series can cover earlier ones. In a stacked area chart, Excel accumulates series values, and in a 100% stacked area chart it shows each series as a proportion of the total. These chart types emphasize filled shapes and their boundaries, rather than offering the same curve controls as a line chart.
For example, if monthly values are 10, 14, and 11, Excel connects the plotted points with straight segments. The chart does not calculate extra data points or infer a curved path between the months. The apparent angle of a segment depends on the values and the chart’s dimensions, but its underlying connection is still straight.
Where the smooth-line setting is available
Excel’s Smoothed line option is available for chart types such as line charts and certain XY (Scatter) charts. It changes the way Excel draws the connecting line; it does not change the values in the worksheet. The option is not a general setting that can be applied to every chart type, and it is not available as a native smoothing control for an area chart.
To check the control on a line chart in Excel for Microsoft 365 on Windows:
- Select the chart, then choose Chart Design > Change Chart Type.
- Choose Line, select a line subtype, and confirm the change.
- Click the plotted series to select it, then press Ctrl+1 to open the Format Data Series pane.
- In the pane, choose Fill & Line, expand Line, and select Smoothed line if it is shown.
The setting is applied to a selected series, so a chart with multiple series may require repeating the last step for each one. On Excel for Mac, the chart-type controls are also on the chart-design ribbon; Command+1 is the usual equivalent for opening formatting options for a selected chart element. Names or pane layouts can differ slightly by build. Excel for the web may not expose every desktop formatting option, so use the desktop app if you cannot find the smoothing control.
Best simple workaround: use a line chart
If the main thing you want is a curved trend rather than a filled region, a line chart is the clearest solution. Switch the chart type to Line as described above, then turn on Smoothed line for the relevant series. Choose a line subtype with markers if readers need to see the exact observation points; choose one without markers when the emphasis is on the overall pattern.
A line chart is usually a better choice when you have several series that must be compared. With overlapping area fills, one series can obscure another and make comparisons difficult. Lines preserve each series’ path without covering the values beneath it. If the area’s fill is important, however, changing to a line chart alters the visual message, so consider whether that trade-off is acceptable before changing the chart.
Keep the original data and chart type available until you have checked the replacement. A chart that looks smoother is not necessarily more informative: smoothing is a drawing choice, not a statistical calculation, and it does not make the underlying measurements more precise.
Keeping the filled look with a combo chart
If you need both a filled area and a curved outline, one possible workaround is to plot the data twice: once as an area series and once as a line series. In Excel desktop, select the chart and look under Chart Design > Change Chart Type > Combo for a custom combination. Assign the original series to Area and a duplicate of the same values to Line, then enable Smoothed line for the line series if the control is available.
For this to read as one series, use the same source values, category labels, and primary axis for both plotted series. A secondary axis with a different scale can make the line appear to disagree with the filled area. You may also need to adjust the line’s color and width so it is visible against the fill. Combo-chart choices and formatting can vary depending on the chart and Excel build; if Excel will not combine the selected types, use a line chart or a separate chart rather than forcing a misleading display.
This method is a visual overlay, not a special smooth-area chart. The area boundary itself remains based on straight connections; the duplicate line is the curved element placed over it. Keep the legend understandable, since Excel may list both series. You can rename the duplicate series or remove a redundant legend entry if readers would otherwise think the chart contains two different measures.
When smoothing can mislead
A smoothed curve can look polished, but it may suggest values between observations that were never measured. Depending on the spacing and shape of the data, the curve can also bend past a plotted point or imply a rise, fall, or turning point that is not evident from the observations alone. This is especially worth considering when categories are dates, when points are far apart, or when the data contains abrupt changes.
Suppose a monthly series jumps sharply from 10 to 30 and then falls to 12. Straight segments show the measured values and the direct connections between them. A smoothed line may round the peak and dip, making the change appear gradual or creating a curve that passes above or below the actual observations. It does not add evidence about what happened between months.
- Use a straight line when readers need to judge the observed values and their changes accurately.
- Consider smoothing for a presentation-oriented view of a dense, continuous series, but retain markers or labels if exact observations matter.
- Do not use smoothing to imply a forecast, confidence interval, or statistical trend; those require separate analysis.
- Be cautious with stacked areas: a curved overlay can be difficult to interpret because each stacked boundary represents accumulated values.
Choosing the right chart for the question
Choose the chart based on what the audience needs to compare, not solely on whether a curve is available. A standard area chart can emphasize the magnitude of one series over time. A stacked area chart is suited to showing how parts contribute to a total, although it can make comparisons between middle series harder. A 100% stacked area chart emphasizes changing proportions rather than absolute totals.
A line chart is often preferable for comparing several time series, particularly when values cross or overlap. An XY (Scatter) chart is useful when the horizontal values are genuinely numeric and unevenly spaced, rather than simply a sequence of categories. Excel’s scatter chart options include smooth-line variants, but they use numeric x-values and are not interchangeable with category-based area charts.
For example, if you record daily temperature at irregular times, a scatter chart can represent the actual time intervals on the horizontal axis. If you have one observation for each month and the months are equally spaced categories, a line chart may be easier to read. The choice of chart type affects how spacing and relationships are communicated, independently of line smoothing.
Common problems and checks
If Smoothed line does not appear, first check the chart type and selection. Clicking the chart background selects the chart area; clicking a plotted line or area selects a series. The formatting pane changes according to what is selected. A line chart is the first thing to try if you are looking specifically for the smoothing checkbox.
- The chart still looks angular: Confirm that you selected the data series rather than the chart area, and that the chart is a compatible line or scatter type.
- Only one series looks smooth: Apply the setting separately to each series that should use it.
- The area and overlay line do not match: Check that both series reference the same values and categories and use the same axis scale.
- The curve looks too rounded: Turn smoothing off or use a straight line; Excel’s curve is a display treatment, not a setting for controlling how closely the line follows a desired trend.
- The control is missing in a browser: Open the workbook in desktop Excel and check the selected chart type and series.
Also check for blank cells, hidden rows, or dates Excel has interpreted unexpectedly. Those issues affect which points are plotted or how they are spaced; smoothing cannot correct a data-layout problem.
Frequently Asked Questions
Can you smooth the lines in an Excel area chart?
No, Excel does not provide a native Smoothed line option for an area chart. Change it to a line chart for a supported smoothing control, or try a combo chart with a duplicate line series if retaining a fill is essential.
How do I make an Excel line chart smooth?
Select the line series, press Ctrl+1 on Windows, and open Fill & Line > Line in the Format Data Series pane. Select Smoothed line if available. On Mac, use Command+1 to open formatting for the selected element.
Does smoothing change my spreadsheet data?
No. It changes the chart’s rendering of the line between plotted points. It does not add worksheet values, calculate a moving average, or create a forecast.
Can I make a stacked area chart smooth?
Not with a native smooth-boundary option. A duplicate line series may be overlaid in a combo chart, but stacked areas are already cumulative and a curved overlay can make the boundaries harder to interpret.
Is a smooth line chart more accurate?
Not automatically. It may look less angular, but it can imply a path between observations that was not measured. Use straight lines or markers when communicating exact observations matters more than visual softness.
Related
- Count Numbers vs Count in Excel PivotTables
- Copy Paste in Excel: Keep Column Widths When Pasting
- Copy an Entire Excel Spreadsheet to a New File
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Combo Chart: Stacked Bar and LineIn Excel for Microsoft 365 on Windows, you can combine stacked columns and a line by selecting your…
- PIVOT Charter School Chico, CA: Programs and EnrollmentPIVOT Charter School in Chico, California, is a public charter school associated with the North Valley area and…
- Automated Gantt Chart in Excel: Setup and LimitsYes. In Microsoft Excel for Microsoft 365 on Windows, you can make a Gantt chart update automatically by…
- Excel Pivot Table Grand Total at Top: What WorksYou cannot move a PivotTable’s built-in grand total row to the top in Excel for Microsoft 365 on…
- Excel Trendline Types and When to Use EachExcel has six trendline types: linear, exponential, logarithmic, polynomial, power, and moving average. Choose one based on the…
- Pivot Columns in Power Query: How to Reshape DataTo pivot columns in Power Query, select the column whose distinct values should become new headers, then choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.