Excel does not provide a native smooth-curve switch for an area chart. In Microsoft 365 for Windows, create one with Insert > Insert Line or Area Chart > 2-D Area; if you need a curved outline, use a smoothed line chart instead or add carefully chosen intermediate data points to make an area chart look less angular.
Why area charts look angular
An area chart plots values at data points, joins those points with straight segments, and fills the region between the plotted series and its baseline. With monthly data, for example, Excel connects January to February and February to March with straight edges. The fill makes those edges prominent, particularly when values change sharply or the chart has only a few points.
That geometry is different from a line chart option such as Smoothed line. Excel can draw a curved line for supported line and XY scatter series, but an area chart is a filled shape rather than just a line. The regular area-chart choices control the chart’s layout and stacking; they do not turn its boundary into a smooth curve. Adding a rounded-looking line elsewhere in the chart does not change the underlying area boundary.
Smoothness is not always an improvement. A curve between two observations suggests a continuous path, even when the source only records separate totals. For monthly revenue or quarterly energy use, straight segments can be a more candid representation of what is known.
Create a standard area chart
Arrange the data with categories in the first column and one or more numeric series in adjacent columns. For example, put months in A2:A13, and one product’s sales in B2:B13, with headers in row 1. Select the complete range, including headers, then choose Insert > Insert Line or Area Chart > 2-D Area. Excel uses the first column for category labels and each numeric column as a separate series.
To refine the chart, select it and use the Chart Design and Format tabs. Chart Design > Add Chart Element lets you add a chart title, axis titles, or a legend. If Excel assigns the months and series in the wrong direction, use Chart Design > Switch Row/Column. To change between regular, stacked, and 100% stacked area, choose Chart Design > Change Chart Type and select the corresponding area type.
On Excel for Mac, the chart-creation and chart-type controls are also on the ribbon, although their placement and the formatting pane can vary slightly by release. Select the chart and look under Chart Design for Change Chart Type. Excel for the web has chart controls too, but some detailed formatting choices may be more limited than in the desktop app.
What the area-chart types show
- Area: Each series is plotted from the horizontal axis. Use it when the overall size of each series matters and the series do not obscure one another too much.
- Stacked Area: Series are added on top of previous series. This shows how component values contribute to a total, but the vertical position of later series is harder to compare across categories.
- 100% Stacked Area: Each category is scaled to 100%. This emphasizes changing proportions, not absolute totals. A component can occupy a larger share even while its actual value falls.
These types answer different questions; none smooths the edges. For instance, if two product lines have monthly sales of 40 and 60 in January and 70 and 30 in February, a stacked area chart emphasizes a combined total of 100 in each month and the shifting mix. A regular area chart emphasizes the series’ values separately, although the filled shapes may overlap visually.
Workarounds for a smoother appearance
The simplest honest option is to use more observations when they exist. If a process is measured daily but the chart currently shows only monthly totals, plotting the actual daily measurements may create a more gradual outline. Do not invent intermediate observations just to make a chart look polished; a visually smooth line is not a substitute for better source data.
A second option is to add intermediate values derived from a documented method, then plot those values in an area chart. This can make the polygon’s straight sections shorter and its outline appear smoother at normal viewing size. It is still a series of straight edges, not a true curved boundary. The added points are estimates, so label or document them clearly and avoid presenting the expanded series as additional measurements.
A third option is to use a line chart when the curve itself is more important than the filled region. Create a line chart, select the data series, open Format Data Series, and in the formatting pane look under Fill & Line > Line for Smoothed line, if that option is available for the selected chart and series. A line chart does not fill the space under the line like an area chart. The checkbox and available formatting can differ by chart type and Excel build; it is not a hidden area-chart setting.
You can also make a combo chart with an area series and a smoothed line series. This may give the impression of a curved edge, but the line and area are separate plotted objects and can diverge between data points. If using this visual treatment, make sure the line represents the same values and axis as the filled series, and check that the overlay does not imply more precision than the data supports.
Choose the chart for the question
Before looking for a smoothing control, decide what a reader needs to compare. A line chart is usually easier for comparing several trends because each series has its own trace. An area chart is useful when emphasis on magnitude or contribution is more important than precise point-to-point comparison. With multiple filled series, colors and overlaps can make small changes difficult to read.
- Use a regular area chart for one principal series or a small number of series whose values need to be seen against the baseline.
- Use stacked area when the series form meaningful parts of a total and the total itself matters.
- Use 100% stacked area when the question is about composition or share over time.
- Use a line chart when comparing the direction and timing of several series is the priority.
- Use an XY scatter chart when both horizontal and vertical values are numeric and the actual spacing between x-values matters. A standard area chart generally treats its horizontal categories as evenly spaced.
For example, if dates are irregular—perhaps measurements were taken after 1, 2, and 10 days—an area chart’s category spacing can give a misleading sense of time. An XY scatter chart positions points according to their numeric x-values and is often the more appropriate choice. It can use a smoothed line, but it will not provide the same built-in filled area as an area chart.
Make an area chart easier to read
A chart can look smoother or clearer without changing its geometry. Reduce unnecessary series, use distinct and color-blind-conscious colors, and keep the horizontal axis labels readable. A restrained fill transparency can help overlapping series remain visible, but too much transparency can make colors difficult to distinguish. Select a series and use Format Data Series to adjust its fill and border.
Consider the vertical axis as well. Area charts commonly begin at zero because the filled distance from the baseline is part of the visual encoding. Truncating the axis can exaggerate differences and make the area seem disproportionate. If a nonzero minimum is necessary for a specific analytical reason, label the scale clearly and consider whether a line chart would communicate the comparison more fairly.
For a long time series, showing every category label can create clutter. Keep the data intact but adjust label intervals or make the chart wider, rather than removing observations without explanation. A clear title, units on the vertical axis, and a legend with meaningful series names help readers understand what the filled regions represent.
Common problems and checks
If the chart looks like a solid block, confirm that the series are not overlapping in a regular area chart or that one series does not dominate the scale. Try a line chart for comparing overlapping trends, or a stacked area chart only if the data represent components that should be added together. Stacking unrelated series changes their apparent vertical positions and can mislead.
If categories appear in the wrong order, check the source order and the horizontal axis settings. If Excel treats values as separate series when they should be categories, use Chart Design > Switch Row/Column. If a blank cell creates an unexpected break, select the chart and open Chart Design > Select Data > Hidden and Empty Cells to inspect the available treatment. The choices depend on the chart type and Excel version; connecting across blanks can imply values that were not recorded.
Finally, check whether a curve is communicating a real pattern or merely decorating the chart. A smoothed line can overshoot between points, especially when values change abruptly. The curve may appear to rise above or fall below observed values, even though no such measurement exists. For reporting, retain a chart type that reflects the data and explain any interpolation or smoothing method used.
Frequently Asked Questions
Can I make an area chart smooth in Excel?
Not with a built-in smooth-area setting in Excel for Microsoft 365. You can make the outline look less angular by plotting more legitimate observations or documented interpolated points, or switch to a line chart with a smoothed line if a filled area is not essential.
Where is the Smoothed line checkbox in Excel?
For chart types and series that support it, select the plotted series, open Format Data Series, and look in Fill & Line > Line. The option is associated with line-style series, not a general setting for a filled area chart. If it is absent, the selected chart or series does not offer that control.
Can a combo chart show a smooth filled area?
A combo chart can place a line series over an area series, but the line’s curve does not curve the area’s fill boundary. Because the two are separate, verify that they use the same values and axis and that their visual difference will not confuse readers.
Is a stacked area chart smoother than a regular area chart?
No. Stacking changes how series are positioned and how their values relate to the total; it does not change straight segments into curves. Choose stacked area for meaningful parts of a whole, not as a smoothing technique.
Should I smooth a chart with only a few data points?
Use caution. A curve drawn through a few observations may suggest a continuous trend or intermediate values that were never measured. A standard line or area chart, with a clear time scale and source, is often the more transparent choice.
Related
- Password Protect an Excel Spreadsheet: Steps and Safety
- Password Protect Multiple Excel Files at Once in Excel
- Password Protect an Excel File from Being Opened
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Chart IF Formula Examples in ExcelYes. In Excel, use an IF formula to create chart-ready values in helper columns, then select those values…
- Excel Sparklines: How to Make Horizontal Bar ChartsExcel for Microsoft 365 does not have a horizontal-bar sparkline type: its built-in sparklines are Line, Column, and…
- Excel Area Chart Change Order: Move Series CorrectlyTo change the order of series in an Excel area chart, select the chart and choose Chart Design…
- How to Add Column Sparklines in Excel: Quick GuideTo add a column sparkline in Microsoft Excel for Microsoft 365 on Windows, select the cell where it…
- Excel Trendline Equation: How to Get It From Data in ExcelTo get an Excel trendline equation from data, make a chart, select its data series, and add a…
- Creating an Org Chart in Excel: Steps and Options ExplainedTo create an org chart in Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.