To fill an area in an Excel chart, select the data series, right-click it, choose Format Data Series, then open Fill & Line and choose a fill color. If you want color beneath a line, change the chart to an Area chart or use a combo chart. The right method depends on whether you mean the data series, the space under a line, or the chart background.
The steps below are for Microsoft Excel for Microsoft 365 on Windows. You can use the same formatting pane in recent Mac versions, although ribbon labels and pane placement can vary slightly. Excel for the web has fewer chart-formatting options; if a setting is missing, open the workbook in the desktop app.
What You’ll Need
- An Excel workbook containing categories and numeric values, such as months in one column and sales in the next.
- An existing chart, or a selected data range from which to create one.
- Excel for Microsoft 365 on Windows for the full set of chart-formatting controls described here.
Step-by-Step
- Decide which area you want to color. An Area chart fills the region from a data series down to the chart’s value axis. A Line chart normally shows only lines and markers, not a filled region below them. The Plot Area is the rectangle behind the data, while the Chart Area includes the entire chart object, including its title and legend. Identify the target first so you do not accidentally color the background when you mean to fill a data series.
- Prepare or check your data. Put category labels, such as dates or product names, in the first column, and put numeric values in the next column or columns. Include clear headers. Select the whole range, including headers, when creating a chart. Blank cells, text mixed into a numeric column, or incorrect category labels can make the result look as if the fill has failed, so check the source range before changing the appearance.
- Create an Area chart if you do not have a chart yet. Select the data range, then choose Insert > Insert Line or Area Chart and select a 2-D Area option, such as Area. Excel inserts the chart with a filled series. For multiple series, choose the basic Area chart if you want each series shown against the axis; choose Stacked Area only when the values are meant to accumulate. Avoid 3-D styles when precise comparison matters, because perspective can make values harder to judge.
- Change an existing chart to an Area chart if appropriate. Click the chart, choose Chart Design > Change Chart Type, and select Area. Pick the basic, stacked, or 100% stacked subtype that matches what the values represent, then confirm. This changes how the data is displayed, not just its color. If the chart contains several series, inspect the result: overlapping filled series can hide one another, and stacked types change the meaning of the vertical totals.
- Select the series whose fill you want to format. Click once on the colored region of the chart to select the series. If a single click selects the whole chart, click the region again carefully or right-click it and choose Format Data Series. The formatting pane title should identify the selected data series. If it says Format Chart Area or Format Plot Area, you selected a background instead; click the data region again.
- Open the fill controls. In the Format Data Series pane, select the Fill & Line icon, which looks like a paint bucket. Expand Fill and choose Solid fill. Use the color control to pick a theme color or another color. A theme color is often a good choice because it coordinates with other workbook elements and can update if the workbook theme changes.
- Adjust the fill so the chart remains readable. Use the Transparency control to make the color lighter and allow gridlines or other series to show through. A moderate level can help when a filled region overlaps another series; the best setting depends on the chart and the color. Keep enough contrast between the fill, the chart background, and any line drawn along the series. Avoid a very dark opaque fill if it obscures labels or hides data behind it.
- Keep or remove the series border as needed. In the same pane, expand Line to choose a border color, width, or line style. A visible outline can make the top edge of the filled area easier to follow. Choose No line only if the boundary is not important or the chart looks too busy. If you need to format a line separately from the filled shape, consider a combo chart instead of relying on a single series style.
- Fill the space beneath a line while keeping a line visible. If you already have a Line chart, select it and use Chart Design > Change Chart Type to switch the relevant series to Area. For greater control, use Chart Design > Change Chart Type > Combo, assigning an Area type to one series and a Line type to another. This commonly requires a duplicate of the values: format one copy as the filled area and the other as the line. Keep both on the same axis unless the data genuinely uses different scales, and check that the line is visible above the fill.
- Format the chart background instead when that is your goal. Click an empty part inside the axes to select the Plot Area, or click the outer chart background to select the Chart Area. Right-click the selected region and choose Format Plot Area or Format Chart Area. In the pane, open Fill & Line and set a solid fill or choose No fill. This colors the background, not the area beneath a data series.
- Review the finished chart. Check the legend, axis labels, gridlines, and every series at normal viewing size. Confirm that the fill does not imply a total or comparison that the data does not support. Click outside the chart to close the formatting pane, then save the workbook. If the chart will be printed or viewed in grayscale, use a sufficiently clear boundary or other visual distinction rather than depending on color alone.
Common Mistakes
Formatting the wrong object. Excel distinguishes the data series, Plot Area, and Chart Area. A fill applied to the wrong selection may cover the whole background or appear to do nothing. Check the name at the top of the formatting pane and select the series again if necessary.
Choosing a stacked chart by habit. A Stacked Area chart adds series on top of one another, so the upper boundary represents cumulative values. That can be useful for showing composition, but it is not equivalent to drawing several independent series from zero. Use a basic Area chart when the goal is to compare individual values against the axis.
Using an opaque fill over other data. A solid area can conceal lines or other series behind it. Increase transparency, adjust the series order, or use a combo chart with a separate line series. Do not assume that changing the fill color alone will resolve overlap.
Confusing the background with the data fill. If the whole rectangle changes color, you likely formatted the Plot Area or Chart Area. If only the region associated with the values changes, you formatted a series. Select the correct object before adjusting the fill.
Expecting an Area chart to shade between two lines. A standard Area chart fills from a series to the axis baseline, not automatically between two arbitrary series. When the purpose is to show the gap between two values, use a purpose-built stacked-area setup or another chart design, and verify that the visual communicates the intended difference.
Tips
- Use a lighter fill for charts with several series, and reserve stronger colors for a single series you want to emphasize.
- Choose chart types based on what the numbers mean before polishing colors. An area fill can make magnitude and accumulation feel more prominent than a line alone.
- For an area-plus-line combo, keep the duplicated series synchronized if the source data changes. A chart based on the same source values is easier to maintain than manually typed copies.
- Use the legend to clarify what each color represents. If a duplicated series is only there to draw the line, consider whether the legend should be edited so viewers are not confused by duplicate labels.
- On Windows, right-clicking a chart element is a quick route to its formatting command. On Mac, use the equivalent control-click or right-click and look for the format option; the pane may appear at a different side of the window.
- In Excel for the web, basic chart selection and some formatting are available, but advanced options can differ. If you cannot find a specific fill or combo-chart control, choose Open in Desktop App and continue there.
Troubleshooting
The fill option is missing. Confirm that a data series is selected and that the pane says Format Data Series. If you selected a line in a Line chart, the pane may show line controls but no meaningful area fill because that chart type does not draw an enclosed area. Change the series to Area or use a combo chart.
The entire chart turns one color. Undo the change with Ctrl+Z on Windows or Command+Z on Mac, select the data region rather than the background, and apply the fill again. If the chart is difficult to click, use the chart’s selection controls or carefully right-click the intended element.
One series hides another. Reduce the fill transparency or change the chart design so overlapping series are easier to distinguish. For a combination of an area and a line, use a Combo chart and make sure the line series remains visible. If you adjust series order through Chart Design > Select Data, inspect the result because overlapping behavior can depend on the chart type and series order.
The area begins at an unexpected level. Check whether the chart is Stacked Area or 100% Stacked Area, and check the vertical axis minimum. Stacked types build on other series, while a manually changed axis minimum can make the baseline appear different. Return to a basic Area chart or restore an appropriate axis scale if the display does not match the intended comparison.
Categories or values look wrong. Choose Chart Design > Select Data and confirm the chart data range, series names, and category labels. Make sure values are stored as numbers rather than text and that the selected range does not include unrelated cells. Correct the source data or range, then review the fill again.
Frequently Asked Questions
How do I fill the area under a line in Excel?
Change the Line chart to an Area chart using Chart Design > Change Chart Type. If you want the line itself to remain prominent, use a Combo chart with an Area series and a separate Line series, then format the area with a suitable color and transparency.
Can I make the fill transparent?
Yes. Select the data series, open Format Data Series > Fill & Line > Fill, choose Solid fill, and adjust Transparency. If the control is unavailable, verify that you selected a series rather than a chart background.
How can I fill only the space between two lines?
A regular Area chart fills from each series toward the axis baseline; it does not automatically shade only the gap between two lines. A stacked-area construction with helper data can create that effect, but it needs careful setup so the displayed values still represent the intended difference.
Why does my area chart hide the other series?
An opaque fill can cover series that overlap it, and some area chart types stack series. Try a more transparent fill, use a basic rather than stacked Area chart when appropriate, or create a combo chart that separates the fill and line.
Can I fill the background instead of the data area?
Yes. Select the Plot Area inside the axes or the Chart Area around the whole chart, open its format pane, and choose a fill under Fill & Line. The Plot Area is the graph’s inner background; the Chart Area includes the surrounding chart elements.
Related
- How to Enable Freeze Panes in Excel
- Forecast Sheet in Excel 2007: What You Can Do Instead
- How to Enable Merge and Center in Excel: Quick Fixes
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Gantt Chart Bar Formula: Setup and Date TipsFor a date-grid Gantt chart in Excel, use the conditional-formatting formula =AND(H$1>=$B2,H$1<=$C2). With task start dates in column…
- Agile Gantt Chart in Excel: Plan Sprints and ReleasesYes. You can make an Agile Gantt chart in Microsoft Excel by listing work items, adding start and…
- Excel Pivot Table Org Chart: Options and WorkaroundsAn Excel PivotTable cannot turn employee records into a graphical organization chart with connected boxes. It can summarize…
- HR Dashboard in Excel: Metrics, Setup, and Best PracticesAn HR dashboard in Excel is a concise, refreshable view of workforce measures such as headcount, turnover, hiring,…
- Google Sheets Chart Not Showing All Data? How to Fix ItIf a Google Sheets chart is missing data, first check its source range in the Chart editor, then…
- Excel Pivot Table by Week: Group Dates or Add a Week FieldYes. In Excel for Microsoft 365 on Windows, put a real date field in a PivotTable’s Rows area,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.