To format a chart area in Excel for Microsoft 365 on Windows, select the chart, right-click its outer background, and choose Format Chart Area. In the formatting pane, change the chart area’s fill, border, or effects; use the selection list on the Format tab if you cannot select the area directly.
What the chart area includes
The chart area is the overall chart container. It includes the plot area, where Excel draws the data, as well as chart elements such as the title, legend, axes, and data labels when those elements are present. Formatting the chart area therefore affects the chart’s outer background or outline, not necessarily every visible region inside it.
The plot area is a separate part of the chart: it is the region containing the data series and, usually, the axes and gridlines. It can have its own fill and border. If you give the chart area a colored fill but the plot area remains white, the chart may show a colored margin around a white plotting region. That is expected; format both areas separately if you want them to match.
A chart is also distinct from the worksheet cells behind it. The chart area is part of the chart object, which can be moved or resized on the sheet. Its fill setting controls the chart object’s background, while cell formatting controls the worksheet itself.
Select the chart area reliably
Click the chart once to select the chart object. Then use either of these methods to target the chart area:
- Right-click a blank part of the chart background, outside the plot area and away from the title, legend, or other elements, and choose Format Chart Area.
- With the chart selected, open the Format tab. In the Current Selection group, choose Chart Area from the selection list, then choose Format Selection.
The second method is useful when the chart has a large plot area, when several elements overlap, or when a click keeps selecting the wrong object. The selection list identifies the chart element that will receive formatting. Check that it says Chart Area before changing settings.
Excel displays contextual Chart Design and Format tabs when a chart is selected. If those tabs disappear, click the chart again. In Excel for Mac, select the chart and use the formatting controls or context menu to open the chart-area formatting options; the ribbon layout can differ from Windows. In Excel for the web, available chart-formatting controls may be more limited than in the desktop app, so use desktop Excel for detailed formatting if a setting is missing.
Change the chart background
In the Format Chart Area pane, open Fill & Line, then expand Fill. Depending on the chart and Excel version, choices can include No fill, Solid fill, Gradient fill, Picture or texture fill, and Pattern fill. For a straightforward report, a solid fill or no fill is usually easiest to read and maintain.
For a solid fill, choose Solid fill and select a color. Use a restrained background so data marks, labels, and gridlines remain easy to distinguish. If you want the worksheet to show through the chart’s outer background, choose No fill or use transparency where available. Remember that this only changes the chart area: an opaque plot-area fill can still cover the worksheet inside the plotting region.
A gradient or picture can be useful for a designed presentation, but it can compete with the data. If using one, check that the chart remains legible at its final size and when printed. Picture and texture options can also make a workbook larger or create inconsistent results when shared across devices, so a simple fill is often more portable.
To change the background behind the data rather than the chart’s outer margin, select the plot area and format its fill separately. A practical example is a chart with a light gray chart-area fill and a white plot-area fill: the gray provides separation from the worksheet, while the white keeps the data region uncluttered.
Format the outline and visual effects
To set an outline, use the Line controls in Fill & Line. Depending on the available options, you can remove the line or choose a solid line and adjust its color, width, and other line properties. A thin, neutral outline can help a chart stand out against a busy worksheet. A thick or brightly colored border can draw more attention than the data, so use it only when that emphasis is intentional.
The Format Chart Area pane may also offer Effects, such as shadow or glow controls. Effects are optional decoration, not a requirement for a readable chart. Subtle effects may help separate a chart from a slide-like layout, but shadows can look heavy in a printed report and may not match the rest of a workbook. Preview the chart at its actual display size rather than judging an effect only while zoomed in.
Formatting the chart area does not automatically format the title, legend, axes, or data series. Those are separate chart elements with their own controls. If a border appears around the title rather than around the whole chart, Excel has selected the title; use the Current Selection list to choose Chart Area before changing the outline.
Make formatting fit the chart’s purpose
Choose chart-area styling based on where the chart will be read. A chart on a worksheet with a white background often needs no fill and no border, particularly when it is part of a clean dashboard. A chart placed among colored cells may benefit from a solid light fill or a fine outline to define its edges. A chart intended for a presentation may need stronger separation, but the data should remain the most prominent part.
Before settling on a color, consider contrast and accessibility. Avoid relying on background color alone to communicate meaning; chart series should also be distinguishable through clear labels, markers, or other visual cues. Keep the chart area and plot area sufficiently different from text and data marks. If viewers may print the workbook in grayscale, check that the chart still makes sense without color.
For a consistent workbook, apply similar chart-area settings to charts that serve the same purpose. Excel’s Chart Design tab includes chart styles that can quickly change a chart’s overall appearance, but applying a style may change more than the chart-area background. Review titles, series, and other custom formatting afterward. For precise control, format the chart area and plot area individually rather than expecting one style to set every detail exactly as desired.
Common problems and how to fix them
- The fill seems to do nothing: You may have selected the plot area or another element instead of the chart area. Check the Current Selection list, and also inspect the plot-area fill, which may be covering the center of the chart.
- The whole chart is selected, but the pane shows the wrong options: Selecting the chart object is not always the same as selecting a specific chart element. Choose Chart Area in the Format tab’s Current Selection list, then open Format Selection.
- The background looks different on another sheet or when printed: Check the chart-area and plot-area fills separately, and preview the print layout. A transparent chart area reveals what is behind the chart, which may differ between worksheets.
- The border is too large or visually dominant: Reopen the Line settings and reduce the width, choose a quieter color, or remove the line. A chart does not need a visible outline if spacing already separates it from nearby content.
- Formatting changes after choosing a chart style: A chart style can restyle several elements at once. Recheck the chart area and plot area after applying a style, and make any final adjustments afterward.
Copy, preserve, and review chart formatting
If you are formatting several charts, first finish one chart and use it as a visual reference for the others. Excel’s Format Painter can copy formatting, but the result depends on which chart element is selected and what formatting Excel applies to the target. Verify the destination chart rather than assuming that every element, such as the plot area or title, received the exact treatment you intended.
Save the workbook after making substantial changes, particularly if the chart is part of a report or dashboard. Before sharing, check the chart at the size readers will see, confirm that labels remain readable, and look at both the worksheet view and print preview if printing matters. If the workbook will be opened in Excel for the web or another spreadsheet program, confirm that the background and effects still display acceptably there.
Frequently Asked Questions
How do I format the chart area in Excel?
Select the chart, right-click a blank part of its outer background, and choose Format Chart Area. Alternatively, use the Format tab’s Current Selection list to choose Chart Area, then select Format Selection.
What is the difference between chart area and plot area?
The chart area is the full chart container, including elements such as the title and legend. The plot area is the inner region where Excel displays the data series. They have separate formatting settings.
Why does changing the chart-area fill not change the background behind my data?
The plot area may have its own fill, which can cover the chart-area background in the data region. Select and format the plot area separately if you want to change that background.
Can I make an Excel chart background transparent?
Yes. Select the chart area and choose No fill, or adjust its fill transparency if that option is available. Check the plot area too: its separate fill may remain opaque.
How do I select the chart area when clicking keeps selecting another element?
Select the chart, open the Format tab, and choose Chart Area from the Current Selection list. Then choose Format Selection to open the relevant pane.
Related
- Extract Data from Google Maps to Excel: Practical Options
- Export Excel to Word: Methods and Formatting Tips
- Expand Data Validation Lists in Excel
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Google Sheets Dashboard Creation: Build a Useful DashboardTo create a dashboard in Google Sheets, organize your source data in a clean table, summarize it with…
- Excel Pivot Tables for BI: Uses, Limits, and AlternativesYes. Excel PivotTables can serve as a practical, entry-level business intelligence (BI) tool: they summarize data, reveal patterns,…
- Chart Not Showing in Excel? Causes, Checks, and FixesIf a chart is missing or blank in Excel for Microsoft 365 on Windows, first check whether Excel…
- Excel Mac Chart Creation: Make and Format ChartsTo create a chart in Excel for Mac, select your data, choose Insert > Recommended Charts, select a…
- Excel Line Chart: Change X-Axis ValuesTo change the x-axis labels on an Excel line chart, select the chart, choose Chart Design > Select…
- Excel Pivot Table: Add Filters to Every ColumnExcel does not have one command that adds a single filter to every PivotTable column. To filter across…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.