How to Fill Area Under a Scatter Plot in Excel

Excel does not provide a direct “fill under” option for an XY scatter series. For evenly spaced X values, make an Area chart from the same data; for unevenly spaced X values, keep the Scatter chart and use a manually drawn shape only if an approximate, non-data-linked fill is acceptable.

Why a scatter chart cannot simply be filled

An XY scatter chart positions each point according to its actual numeric X and Y values. That makes it the right choice when horizontal distances matter—for example, when measurements were taken at irregular time intervals. Its data series can show markers and lines, but Excel does not offer a built-in area fill beneath a scatter-series line.

An Area chart looks similar, but it uses a category axis: it spaces categories evenly rather than spacing them according to numeric X distances. Consequently, changing a scatter chart to an Area chart can alter the apparent shape of the data if the X values are uneven. This distinction matters more than the visual resemblance between chart types.

The best option depends on what the chart needs to communicate. If the X values are equally spaced, an Area chart is usually a clean solution. If the data relies on real numeric spacing, retain the Scatter chart and choose a workaround with its limitations in mind.

Use an Area chart when X values are evenly spaced

This method is appropriate when each observation belongs at an equal interval, such as months in sequence or measurements taken every hour. In Excel for Microsoft 365 on Windows:

Arrange the X values in one column and the corresponding Y values in the next. Include clear column headings.
Select both columns, including the headings.
Choose Insert > Insert Line or Area Chart > Area.
Check that the horizontal axis shows the intended labels and that the filled region meets the baseline you expect.
Use Chart Design > Add Chart Element or the chart formatting controls to add a title, axis labels, and other presentation details.

An Area chart fills from the plotted values toward the chart’s baseline, commonly zero. If you want the visual to represent accumulation from zero, make sure zero is the meaningful baseline and is included appropriately in the vertical-axis scale. Avoid assuming that a filled shape automatically means a total or a quantity accumulated over time; the chart is a visual representation of the supplied values.

For example, readings recorded at 9 a.m., 10 a.m., 11 a.m., and noon are regularly spaced. An Area chart can show the changing reading with a filled region while keeping those intervals visually equal. If the readings are instead at 9 a.m., 9:10 a.m., 10:30 a.m., and noon, an Area chart gives the four categories equal horizontal spacing, which misrepresents elapsed time.

Keep the scatter chart for irregular X values

When X values are unevenly spaced, a normal Area chart is not a faithful replacement. Excel’s XY Scatter chart is designed to preserve numeric horizontal distances, so keep it when those distances carry meaning. You can still make the chart easier to read by formatting the line, markers, gridlines, and axes, even though those choices do not create a filled region.

A manual shape can imitate a shaded area: select the chart, choose Insert > Shapes, and draw a freeform polygon within the plot area, following the line and closing the shape along the chosen baseline. Apply a fill color and transparency, then place the shape behind the data series if the chart’s selection and layering controls allow it. Work carefully around the axis labels and plot-area boundary.

This is a visual overlay, not a chart series. The shape is not linked to the underlying values and will not recalculate when the data changes. It can also become misaligned if you change axis limits, resize the plot area, or add data. Treat it as a presentation-only annotation, and recheck it after edits. On Mac, the Insert > Shapes workflow is similar, though ribbon layout and drawing controls can differ. Excel for the web may have fewer shape-editing options than the desktop app.

Prepare the data and choose a meaningful baseline

Before building a filled chart, check the data rather than relying on the chart to resolve inconsistencies. Each X value should match the Y value on the same row. Sort observations by X when a connected line is meant to show progression from left to right; connecting unsorted points can create a misleading path. Check for blank cells, text stored as numbers, duplicate X values, and unexpected negative readings.

Decide what “under the plot” means in the context of the data. It may mean filling down to zero, down to a fixed threshold, or between two measured curves. A standard Area chart commonly fills to its baseline; it is not automatically a flexible way to shade between arbitrary boundaries. If the intended reference is a threshold other than zero, describe that clearly and consider a different visualization or a carefully constructed chart rather than implying the area is measured from zero.

Area charts can also obscure information when several series overlap. With multiple series, one filled region may cover another or make comparisons hard to interpret. If the aim is to compare lines, an unfilled line or scatter chart may be clearer than adding color beneath every series.

Format the filled chart for readability

Once you have chosen a chart type that fits the data, keep the fill visually subordinate to the observations. A pale fill, a contrasting outline, and readable axis labels help preserve the line’s shape. Strong, opaque colors can make small changes difficult to see, particularly when gridlines or markers are hidden.

Use a clear baseline. Check the vertical-axis minimum and maximum. A cropped scale can make a small variation look dramatic, while a zero baseline may flatten changes when the values are large.
Distinguish data from decoration. Keep markers or a visible outline when readers need to identify individual observations.
Label units. Name both axes and include units where relevant, such as minutes, degrees, or millimeters.
Use color with purpose. A single fill can emphasize one series; multiple similar fills can make the chart ambiguous.

For a manual shape overlay on a scatter chart, use a fill that is transparent enough to leave markers and gridlines visible. Recheck its alignment after any chart-formatting change. If it takes repeated adjustment to keep the overlay aligned, that is a sign the approximation may not be suitable for a chart that will be updated or shared as an analytical result.

Common problems and misconceptions

“I changed the chart to Area, but the curve looks different.” The most likely reason is that your numeric X values were unevenly spaced. An Area chart treats the horizontal entries as categories at equal intervals. Return to a Scatter chart if preserving numeric spacing is essential.

“The fill starts at the bottom of the chart, not where I expected.” Review the vertical-axis scale and the chart’s baseline. The bottom edge of the visible plot is not necessarily the value you intend to use as a reference. Be explicit about whether the fill should represent values relative to zero or another level.

“The shape no longer lines up after I edit the chart.” A manually drawn polygon does not follow the data or axis scaling. It must be repositioned after changes to the data, chart size, plot area, or axis limits. For an updating chart, do not present the shape as if it were a calculated data fill.

“Can I use error bars to shade under the curve?” Error bars indicate variation or uncertainty around points; they are not a continuous fill beneath a line. Using them as decoration can give readers the wrong impression about what the chart represents.

Choose the chart type that matches the question

Use an Area chart when the horizontal categories are equally spaced and a filled presentation adds useful emphasis. Use an XY Scatter chart when the X values are numeric and their actual distances matter, including irregular time intervals or scientific measurements. If the goal is to compare two boundaries or show a range, consider whether the chart should display the gap between those series rather than fill down to zero.

There is no universal choice that preserves both scatter-plot spacing and provides a native under-the-line fill in Excel. For a report that needs accurate, updateable numeric spacing, an unfilled scatter chart is generally more dependable than a decorative overlay. If a filled look is essential, document the limitation and verify that the visual does not suggest values or areas the data do not support.

Frequently Asked Questions

Can Excel fill under an XY scatter plot automatically?
No. Excel does not provide a built-in fill-under setting for an XY Scatter series. Use an Area chart for evenly spaced categories, or a manual overlay as a non-linked visual approximation.

Will an Area chart preserve my scatter plot’s X-axis spacing?
No. An Area chart uses category positions, which are spaced evenly. If your numeric X values have unequal gaps, the chart will not preserve those distances.

How do I fill under a line in Excel?
If the data points are equally spaced, select the X and Y columns and choose Insert > Insert Line or Area Chart > Area. If the X values are uneven, this changes the spacing, so keep a Scatter chart if accurate X positioning is required.

Can I fill only the region above a target value?
A basic Area chart is not a general-purpose tool for shading an arbitrary region above a threshold. Decide whether the target is a true baseline and choose a chart method that represents that relationship accurately; do not rely on a manually added shape for a live, changing data series.

Does a transparent shape update when my scatter data changes?
No. A shape drawn over the chart is a drawing object, not a data-driven series. It will need manual adjustment when the plotted line or chart scaling changes.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.