To select the chart area in Excel for Microsoft 365 on Windows, click a blank part of the chart outside the plot area; to select it precisely, select the chart, open the contextual Format tab, and choose Chart Area from the Current Selection dropdown. The chart area is the full chart background, while the plot area is only the region where the data is drawn.
What “Chart Area” Means
A chart is made up of separate elements that can be selected and formatted individually. The chart area is the overall container: it includes the plot area and elements such as the chart title, legend, axes, and data labels when those are present. Selecting it is useful when you want to change the background or border behind the chart as a whole.
The plot area is a component inside that container. It is the region where Excel displays the data series, gridlines, and axes. Its size can change when you add a legend or title, so it does not always fill the full chart. A chart also has other selectable components, including its title, legend, individual axes, and data series.
These distinctions matter because the same formatting command can affect different things depending on what is selected. For example, changing Fill while Chart Area is selected changes the overall chart background. Changing Fill with Plot Area selected affects the inner plotting region instead. Neither action changes the source data.
Select the Chart Area by Clicking
For a chart with open space around the plot, clicking the blank background is usually the quickest method. Aim for an area inside the chart’s outer boundary but outside the graph itself—for example, the space between the plot and the chart border, or an empty area beside the legend. A click directly on a title, axis, legend, data point, or gridline may select that element instead.
- Click the chart once so Excel activates it. Contextual chart tabs appear on the ribbon.
- Click an empty part of the chart background, away from the plotted data and other visible elements.
- Check the selection label on the Format tab. It should say Chart Area.
Excel can select an object even when its fill is transparent or absent, so the chart area may not look like a distinct colored region. If clicking seems to select the whole chart or the wrong component, use the Current Selection dropdown instead of repeatedly clicking small gaps.
Use the Current Selection Dropdown
The Current Selection control is the most dependable way to choose a specific chart component, particularly when the chart is crowded. In Windows desktop Excel, click the chart, open the contextual Format tab, and locate the Current Selection group. Open its dropdown and choose Chart Area. The control’s displayed name updates to show the selected component.
After choosing Chart Area, use the formatting controls on the Format tab, or open the formatting pane to see options for the selected component. You can also right-click a blank part of the chart and choose Format Chart Area when that command appears. If the right-click menu instead offers Format Plot Area, Excel has identified the inner plotting region; select the chart area through the dropdown to avoid formatting the wrong part.
The dropdown is especially useful when chart elements overlap. For example, a chart title can sit close to the top edge, leaving little room to click the background. The list lets you select Chart Area directly rather than trying to target a narrow strip of empty space.
Format the Selected Area
Once Chart Area is selected, Excel’s formatting controls apply to the overall chart container. Common changes include setting a fill, changing an outline, or adjusting effects. The available controls depend on the chart and the Excel build, but they operate on the selected element—not automatically on every object in the workbook.
- Fill: Add a solid color or choose another available fill treatment for the chart background. A restrained fill can help a chart stand out from a report page.
- Border or outline: Add or adjust a line around the chart. A border can separate a chart from nearby text or other charts.
- Effects: Where available, apply effects to the selected area. Use them sparingly if the chart needs to remain easy to read.
If your aim is to change only the region behind the data, select Plot Area before formatting. If your aim is to change the appearance of the chart title, select the title itself. Selection is not the same as resizing: dragging the outer sizing handles changes the chart object’s dimensions, while formatting changes its appearance.
Chart Area vs. Plot Area and Other Elements
It is common to call the graph’s inner background the chart area, but Excel treats that as the Plot Area. The terms identify different selections, and checking the Current Selection label is a practical way to confirm which one is active.
- Chart Area: The overall chart container and its background.
- Plot Area: The inner region where data series are plotted.
- Chart title: The text heading for the chart, if one has been added.
- Legend: The key that identifies series or categories.
- Data series or point: A plotted group of values or an individual value within that group.
For example, suppose a column chart has a title above the columns and a legend on the right. Selecting Chart Area lets you format the complete background behind those components. Selecting Plot Area changes the backdrop behind the columns and gridlines, but does not necessarily change the space behind the title or legend. Selecting the columns themselves affects the data series, not the background.
Select a Chart Element When the Chart Is Crowded
When a chart has little blank space, selection through the ribbon is usually faster and more accurate than clicking around. After selecting the chart, inspect the Current Selection dropdown for Chart Area. You can also try clicking the chart background and then checking the selection label before making a formatting change.
Keyboard navigation can help when the chart is already selected. Press Tab to move through chart elements, and Shift+Tab to move in the reverse direction; the selection label can help identify the active element. The order may depend on the chart and its contents, so do not assume a particular number of presses will always land on Chart Area. For a precise selection, use the dropdown.
On Windows, the standard chart shortcut is not a special Chart Area key combination. Ctrl+Z can undo a formatting change if the result is not what you wanted, but it is better to confirm the selected element first. On Mac, use Command+Z to undo. These undo shortcuts reverse recent actions; they do not select the chart area.
Windows, Mac, and Excel for the Web
The instructions above describe Excel for Microsoft 365 on Windows. In Excel for Mac, click the chart and look for the contextual chart-formatting controls on the ribbon. Clicking an open area or choosing Chart Area from a selection list, where available, follows the same basic principle: confirm that Chart Area, rather than Plot Area or another element, is selected before changing its appearance. Ribbon organization and the location or wording of controls can vary by Mac release.
Excel for the web also lets you select and format charts, but its ribbon and formatting controls may not match the Windows desktop version exactly, and some chart-formatting options can be more limited. If you cannot find a specific Chart Area control in the web app, try selecting the chart and inspecting the available chart or format options. For detailed formatting tasks, open the workbook in the desktop application if the needed control is not available online.
These differences affect where a command appears, not the distinction between the chart area and plot area. In any version, use the selected-element label or formatting pane to check the target before applying a fill or border.
Common Selection Problems
If Excel keeps selecting the wrong thing, the cause is usually where the pointer lands or how tightly the chart elements are arranged. A few checks can narrow it down:
- The plot area is selected: The click landed inside the graph. Choose Chart Area from the Current Selection dropdown.
- A title or legend is selected: The pointer landed on text or its boundary. Use the dropdown rather than trying to click a tiny gap.
- The whole chart has sizing handles: Excel has activated the chart object. Select Chart Area in the component list before formatting.
- Nothing seems to change: Check the selection label, then confirm that the fill or line option you changed applies to that component. A transparent fill can make the chart background appear unchanged.
- The command is missing: Confirm that the chart is selected and that you are using a desktop or web version with the required formatting control. Ribbon tabs only appear when the chart is active.
One useful habit is to make a small, reversible formatting change first, such as a temporary outline, and confirm where it appears. Undo it if necessary, then apply the desired styling. This can reveal whether Chart Area or Plot Area was selected without changing any chart data.
A Practical Example
Imagine a chart on a worksheet with a white chart background, a pale gray plotting region, and a legend beside the data. To add a thin border around the whole chart, click the chart, choose Chart Area from the Current Selection dropdown, and set an outline. The border should follow the chart’s outer edge. If you instead choose Plot Area and add a border, the line appears around the inner data region and does not enclose the title and legend in the same way.
If the goal is a colored backdrop behind the columns but a white margin around the chart, select Plot Area and change its fill. If the goal is to color the complete chart container, select Chart Area. Thinking first about which visible region should change helps avoid applying formatting to the wrong component.
Frequently Asked Questions
How do I select the chart area in Excel?
Click a blank part of the chart outside the plot area, then verify that Chart Area is selected. For a precise selection, click the chart, open the contextual Format tab, and choose Chart Area from the Current Selection dropdown.
Why can’t I click the chart area?
The chart may have little empty space, or your pointer may be landing on the plot, title, legend, or another element. Select Chart Area from the Current Selection dropdown instead of trying to click a narrow gap.
What is the difference between chart area and plot area?
Chart Area is the overall chart container and background. Plot Area is the inner region where Excel draws the data and gridlines. The two can have different fills and outlines.
Does selecting Chart Area change the data?
No. Selecting the chart area only chooses a chart component. Formatting its fill or border changes appearance, not the worksheet values or the chart’s source data.
How do I format only the background behind the data?
Select Plot Area rather than Chart Area, then apply the fill or outline. Check the selected-element label first so the formatting affects the intended region.
Related
- PowerShell Refresh Excel Power Query: How It Works
- Power Query: Get Excel Files From a Folder in Excel
- Power Query Excel Number Format: What You Can Control
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- 24-Hour Gantt Chart Excel: 24 Setup Ideas That WorkTo make a 24-hour Gantt chart in Excel, put 24 hourly time values across the columns, list tasks…
- Excel Pie Chart: How to Break Its Link in Microsoft WordTo break a linked Excel pie chart in Word for Microsoft 365 on Windows, open the document and…
- Dashboard from Excel Data: Build a Clear, Useful ViewYes. To make a dashboard from Excel data, organize the source as a clean Excel Table, summarize it…
- Radar Chart Excel Tutorial: Create and Format OneTo create a radar chart in Excel for Microsoft 365 on Windows, select a table with category labels…
- Power Pivot Not Showing in Ribbon? Fix It in ExcelIf Power Pivot is missing from the Excel ribbon on Windows, first confirm your Excel edition includes the…
- Excel Pivot Table: How to Change the Data SourceTo change an Excel PivotTable’s source in Microsoft 365 for Windows, click inside the PivotTable, select PivotTable Analyze…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.