How to Edit the Chart Area in Excel

Charts & pivot tables · Updated November 20, 2026

To edit a chart area in Excel, select the chart, open the contextual Format tab, choose Chart Area from Current Selection, then select Format Selection. In the Format Chart Area pane, change the fill, border, or effects. The chart area is the whole chart object; the plot area is the inner region where the data is drawn, so selecting the right one matters.

What You’ll Need

  • A workbook with a chart. To insert one first, select the data and choose Insert followed by a chart type.
  • Microsoft Excel for Microsoft 365 on Windows for the steps below. Excel for Mac has similar chart-formatting controls, although the ribbon layout can differ. Some advanced formatting options are more limited in Excel for the web.
  • Editing access to the workbook. If it is shared or protected, you may need permission to change chart formatting.

Step-by-Step

  1. Select the chart. Click once on the outside edge or a blank part of the chart. Excel should display a border with sizing handles around the full chart and show the contextual Chart Design and Format tabs on the ribbon. If you only see a border around a title, legend, or other single element, click a blank region of the chart to select the whole object.
  2. Choose the chart area specifically. Open the contextual Format tab. In the Current Selection group, open the selection dropdown and choose Chart Area. This is more reliable than clicking around the chart, especially when the plot area fills most of the chart or several elements overlap. On some window sizes, the group may be condensed, but the selection dropdown remains available on the Format tab.
  3. Open the formatting pane. With Chart Area selected, choose Format Selection in the Current Selection group. Excel opens the Format Chart Area pane, usually at the right side of the window. You can also right-click a blank area around the chart and choose Format Chart Area; if the context menu offers a different element, use the selection dropdown instead.
  4. Change the background fill. In the pane, select Fill & Line (the paint-bucket icon), then expand Fill. Choose an option such as Solid fill and use the color control to select a color. Gradient fill, Picture or texture fill, and Pattern fill may also be available. Use No fill if you want the chart area to be transparent and show the worksheet behind it. For most charts, a subtle solid color or no fill keeps labels readable.
  5. Set the outline. In the same pane, expand Border or Line, depending on the pane labels shown in your Excel build. Choose Solid line to add or adjust an outline, then choose its color, width, and any other available line settings. Select No line to remove the chart area’s outline. A thin neutral border can separate a chart from a busy worksheet; a heavy or brightly colored line can draw attention away from the data.
  6. Adjust effects only if they help. Select Effects in the Format Chart Area pane to review options such as shadow, glow, or soft edges when available. Apply effects sparingly: shadows and glows can make a chart look less clear, especially when it is printed or viewed at a small size. If you add an effect, check the chart at its intended display size before keeping it.
  7. Check the plot area separately. The chart area is the entire chart object, including the region behind the chart’s components. The plot area is the inner rectangle where columns, lines, markers, and gridlines appear. If the fill you applied seems hidden or only partly visible, select the plot area using the Current Selection dropdown and inspect its fill settings too. A solid plot-area fill can cover the chart-area color behind it; setting the plot area to No fill lets the chart-area fill show through.
  8. Review the result and close the pane. Click outside the chart to see how it sits on the worksheet, then click it again if you need further adjustments. To change the chart’s overall dimensions, drag a corner sizing handle; to move it, drag its outer edge. Those actions resize or move the chart object, rather than changing the chart-area fill or border. Save the workbook after confirming the chart is readable.

On Excel for Mac, select the chart and look for the contextual Chart Design and Format tabs, then use the selection controls and formatting pane if they are available in your version. The pane may open in a different position. In Excel for the web, select the chart and use the chart formatting controls that appear; if you cannot find a particular fill, line, or effects option, open the workbook in the desktop app to use the full set of controls.

Common Mistakes

  • Formatting the plot area by accident. A click in the data region often selects the plot area, not the overall chart area. The chart area setting affects the whole chart object, while the plot area setting affects the region containing the data. Confirm the selected element in the Current Selection dropdown before making changes.
  • Expecting a chart-area color to appear through an opaque plot area. The plot area can have its own fill. If it is set to a solid color, that color may cover the chart-area fill in the data region. Make the plot area transparent or match the fills if you want a continuous background.
  • Changing the worksheet instead of the chart. Clicking outside the chart may select a cell, so the chart-formatting tabs disappear. Click the chart again, then verify that the contextual tabs return before looking for chart-area settings.
  • Using a picture or strong effect that hurts contrast. Busy backgrounds can make gridlines, labels, and data marks difficult to read. Preview the chart at its final size and consider whether it remains clear in grayscale or when printed.
  • Confusing formatting with sizing. Dragging a handle changes chart dimensions, not the area’s fill or border. Use the Format Chart Area pane for appearance, and use the chart handles or size controls for dimensions.

Tips

  • Start with a simple design. A white or transparent chart area with no border often works well when the chart sits on a clean worksheet. Use a light fill or a subtle outline when the chart needs to stand apart from surrounding cells.
  • Keep contrast consistent. If you use a dark chart-area fill, check the text, axes, gridlines, and data series individually. A chart-area fill does not necessarily recolor every chart element, and some labels may become hard to read against the new background.
  • Use the selection dropdown for precision. Charts can contain many selectable parts, including titles, legends, axes, and data series. Selecting Chart Area from Current Selection avoids repeated clicks and reduces the chance of formatting the wrong element.
  • Make related charts match. If a worksheet has several charts, use the same background and border choices where appropriate. Consistent formatting makes comparisons easier, but do not force a dark or decorative style onto a chart that needs a different treatment for legibility.
  • Check print and export views. Transparent areas can look different depending on the worksheet background or the application used to display an exported file. Use File > Print to preview printed pages, and check the saved or exported chart in its intended destination.
  • Remember the two selection methods. Right-clicking the chart’s blank outer region is quick when Excel identifies it correctly. The ribbon dropdown is the dependable alternative when the chart is crowded or the context menu names another component.

Troubleshooting

The Format tab is missing. Click the chart once. The chart-specific tabs only appear while a chart is selected. If clicking selects a cell or a chart element instead, click the outer chart boundary or select the chart from the worksheet’s available object-selection controls.

The whole chart does not change color. Confirm that Chart Area, rather than Plot Area, is selected. Then inspect the plot area fill: an opaque fill can conceal the chart-area color behind the data region. Set the plot-area fill to No fill when that is the appearance you want.

The color or border option is unavailable. Reopen the selection dropdown and check that the chart area is selected. If the workbook is protected, read-only, or opened with limited permissions, ask for edit access or an unprotected copy. Excel for the web may not expose every desktop formatting choice; try opening the file in Excel for Microsoft 365 on Windows.

The chart looks different after moving or copying it. A chart may appear against a different worksheet background, or its plot area may retain its own fill. Review both area settings and inspect the chart where it will ultimately be placed. If it is embedded in a report or presentation, check its appearance there too.

You cannot find the Chart Area option in the dropdown. First select the chart object, not a cell or a chart component. If the dropdown is hidden because the ribbon is narrow, maximize the Excel window or expand the ribbon. As another route, right-click a blank outer part of the chart and choose Format Chart Area.

Frequently Asked Questions

What does Chart Area mean in Excel?
The chart area is the complete chart object, including the space around the plot area and chart elements. The plot area is the inner region where the data is plotted. Each can have separate formatting.

How do I change the background of an Excel chart?
Select the chart, choose Chart Area from the Format tab’s Current Selection dropdown, then open Format Selection. Under Fill & Line > Fill, choose a fill and color. If the inner data region stays a different color, format the plot area too.

How do I remove the border around a chart?
Select Chart Area, open the Format Chart Area pane, and choose No line under the border or line settings. If a line remains around the data region, select and format the plot area separately.

Can I make the chart area transparent?
Yes. Select the chart area and choose No fill in its Fill settings. The plot area may also need No fill for the worksheet background to show through behind the data.

Will changing the chart area affect my data?
No. Changing its fill, border, or effects changes the chart’s appearance, not the worksheet values or the chart’s source data. Be careful not to delete the chart or edit its data range if you only want to adjust its appearance.

Can I edit the chart area in Excel for the web?
Basic chart formatting is available in Excel for the web, but controls can vary and some desktop options may be missing. For a specific fill, border, or effect that you cannot access online, open the workbook in the desktop version of Excel.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

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

Spotted an error in this guide? Let us know.