In Excel, the chart area is the entire chart object, while the plot area is the region inside it where the data is displayed. The plot area sits within the chart area, alongside elements such as the title and legend, so choosing the right one matters when you format or resize a chart.
What the chart area and plot area mean
Think of an Excel chart as a framed display. The chart area is the whole frame and everything placed inside it. It can include the plot area, chart title, axis titles, legend, data labels, gridlines, and—in chart types that use one—a data table. A chart may also have a border or background fill applied to the chart area.
The plot area is the chart’s data-display region. It is where Excel draws the data series, such as columns, lines, markers, or pie slices, and where gridlines appear when the chart type uses them. In a typical column chart, it is the rectangular region behind the columns, inside the axes. Its exact shape and boundaries depend on the chart type and the space needed for labels and other elements.
The two areas are related but not interchangeable. Changing the chart area affects the overall chart object; changing the plot area affects the space available for the data within that object. A chart area can exist with little or no visible plot area—for example, if the chart has no data—while a plot area cannot sit outside its chart area.
How the parts fit together
When you insert a chart, Excel creates an overall chart object and places several chart elements within it. The chart area provides the outer boundary. Excel then arranges the plot area and supporting elements based on the selected chart type, the available chart dimensions, and the presence of titles, legends, labels, and axes.
For example, adding a legend to the right of a chart usually leaves less horizontal room for the plot area. Adding a long vertical-axis title or wide category labels can also reduce the space available for the data. Excel may reposition or shrink the plot area to make room; the chart area can remain the same size.
These elements are separate in the sense that they can be selected and formatted individually. A chart title is not the same object as the chart area, and a gridline is not the plot area. But all of them are arranged within the chart’s overall layout. A data table, when included, appears in the chart area, usually below the plot area, and can take up room that might otherwise be available to the plotted data.
How to select each area in Excel
Accurate selection is the key to formatting the intended part of a chart. Clicking once on a chart usually selects the chart object; clicking a specific element can select that element. Because the plot area may be surrounded by axes, labels, or gridlines, it can take a couple of attempts to select it directly.
- Click the chart once to activate the chart-specific ribbon tabs.
- On the Chart Format tab, find the Current Selection group and open its chart-element list.
- Choose Chart Area or Plot Area from the list. Excel highlights the selected element in the chart.
- Choose Format Selection in the Current Selection group to open the formatting options for that element.
You can also click directly on a blank part of the chart background to select the chart area, or click within the data-display region to select the plot area. If a click selects a series, axis, or gridline instead, use the Current Selection list to switch to the area you want. The exact ribbon layout can vary slightly with window size and Excel updates, but the selection list is the dependable method.
On Excel for Mac, click the chart and use the chart-formatting controls or the Format tab’s selection controls to choose the relevant element. Excel for the web supports common chart edits, but its available formatting controls can be more limited than the Windows desktop version. If a particular selection or detailed format option is not available in the browser, open the workbook in desktop Excel.
Formatting the chart area
Format the chart area when you want to change the chart’s overall appearance or the space occupied by the chart object. With Chart Area selected, the Format Chart Area pane offers settings for fills, borders, and effects, depending on the chart and Excel version. A solid, gradient, or picture fill can create a background behind the entire chart; a border can define the chart’s outer edge.
Resizing the chart area changes the overall chart dimensions. Select the chart and drag a sizing handle on its outer boundary. This is useful when fitting a chart into a report, dashboard, or worksheet grid. The text and plotted region may adjust as the chart grows or shrinks, and Excel may rearrange elements if the new dimensions are tight.
Use restraint with background effects. A strongly colored chart-area fill can reduce contrast with the data, while a heavy border can compete with the plotted values. For a clean report, a plain background and a subtle outline—or no outline—often keep attention on the data. If the chart sits on a colored worksheet or slide, compare the chart’s fill with the surrounding page before deciding whether it should blend in or stand apart.
Formatting and resizing the plot area
Format the plot area when you want to change the background or border behind the plotted data without changing the whole chart’s outer appearance. Select Plot Area and use Format Selection to find its available fill, line, and effect options. For instance, a pale plot-area fill can distinguish the graphing region from a white chart area, while a thin plot-area border can make its edges easier to see.
You can also move or resize the plot area within the chart. Select it and drag its sizing handles or boundary. This can reclaim space for the data if the plot area has become too small, or create more room for category labels or a legend. The chart area does not necessarily change size when you do this. If you drag the plot area too close to the chart edge, however, labels or titles may feel crowded or overlap.
Excel’s automatic layout can adjust the plot area when you add or remove chart elements. To make more plotting room, try moving the legend, shortening a title, reducing label size, or enlarging the overall chart before manually adjusting the plot area. These changes often produce a more balanced result than forcing a large plot area into a chart that lacks room for its labels.
A practical example: making a crowded chart clearer
Suppose a monthly sales chart has twelve category labels, a long chart title, and a legend on the right. The chart object may be wide enough on the worksheet, yet the columns look cramped because the legend and labels occupy much of the available space. The chart area is the entire rectangle containing the title, legend, and graph; the plot area is the smaller region where the columns and gridlines appear.
First, decide whether every element is needed. If there is only one data series, a legend may be redundant. Removing it can give the plot area more width. If the title is long, shorten it or move explanatory detail into a nearby worksheet cell. Then select Plot Area from the Current Selection list and adjust it if the automatic layout still leaves the data too compressed. If the whole chart is too small, enlarge the chart area instead.
Make one change at a time and check whether the labels remain readable. Enlarging only the plot area does not enlarge the chart object, so it cannot create unlimited room. When the chart is too narrow for its contents, resizing the overall chart or reducing nonessential elements is usually the better fix.
Differences across chart types
In a bar, column, line, or scatter chart, the plot area is usually easy to recognize as the region containing the data marks and gridlines. Axes provide reference values or categories around that region. Because axes and labels are separately selectable chart elements, it is more precise to describe the plot area as the data-display region than to assume every visible axis label is part of it.
Pie and doughnut charts have no value axis or gridlines, but they still have a plot area: the space where the slices are drawn. A legend and data labels can use room around the pie, affecting its size and placement. In a 3-D chart, the plotted region can include visual depth, walls, or a floor, so its appearance is less like a simple flat rectangle. The basic distinction remains the same: chart area means the whole chart; plot area means the region used to display the data.
Combo charts can make selection and formatting less obvious because they combine different series types, sometimes with a secondary axis. The chart area still contains the complete chart, and the plot area remains the data-display region. If a click selects an axis or series instead, choose Plot Area explicitly from the Current Selection list rather than relying on the pointer.
Common problems and misconceptions
- Formatting the wrong region: A fill applied to Chart Area changes the background behind the whole chart. A fill applied to Plot Area changes only the data-display region. Check the selected element name before changing its format.
- The plot area seems too small: Titles, legends, axis titles, long labels, and data tables all use chart space. Remove, shorten, or reposition elements that are not essential, or enlarge the chart area.
- The chart background appears unchanged: The plot area may cover the chart-area fill. Select and format each area separately, and check whether either area has a transparent or matching fill.
- Dragging resizes the wrong object: The outer handles resize the chart area; handles on the inner plot-area boundary resize the plot area. Use the selection list if the handles are difficult to distinguish.
- Assuming the plot area is the entire chart: It is only the data-display region. A chart title, legend, and other supporting items can be inside the chart area but outside the plot area.
Frequently Asked Questions
Is the plot area inside the chart area?
Yes. The plot area is a region within the chart area. It displays the chart’s data, while the chart area includes the plot area and the other elements that make up the complete chart.
Does the plot area include the axes?
The plot area is the region where data is displayed, and axes frame or provide scales for that region. Excel treats axes as selectable chart elements of their own, so select the axis separately when you want to format its line, labels, or title.
How do I change the background behind the data?
Select Plot Area using the Chart Format tab’s Current Selection list, choose Format Selection, and change the plot-area fill. To change the background behind the entire chart, select Chart Area instead.
Why does adding a legend make my chart look smaller?
Excel may reserve space for the legend within the chart area, leaving less room for the plot area. Move the legend, remove it if it is unnecessary, or make the overall chart larger to give the plotted data more space.
Can I move the plot area without moving the chart?
Yes. Select Plot Area and drag its boundary or sizing handles. This changes its position or size inside the chart area, though it cannot add space beyond the chart’s outer boundary.
Related
- Budget vs Actual Excel Template: Free Options and Setup
- Budget Template in Microsoft Excel: Find and Use One
- Bps Number Format in Excel: Display Basis Points
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Table Relationships: How to Link DataExcel PivotTable relationships connect separate tables through matching columns in the workbook’s Data Model, so you can summarize…
- Excel PivotTable Charts: How to Create and Use ThemTo create an Excel PivotChart in Microsoft 365 for Windows, click a cell in a PivotTable, choose PivotTable…
- Manual Sort Pivot Chart in Excel: Control Category OrderTo manually sort a PivotChart in Excel for Microsoft 365 on Windows, reorder the chart’s categories in its…
- Excel Pivot Table Date Filter: Last 30 DaysTo filter an Excel PivotTable to the last 30 calendar days, add a helper column to the source…
- Excel Chart Axis Range: Set Minimum and Maximum ValuesTo change an Excel chart’s numeric axis range in Microsoft 365 for Windows, select the chart axis, right-click…
- Excel Pivot Chart Sort by Value: Steps, Tips, and FixesTo sort an Excel PivotChart by value, sort the corresponding field in its PivotTable: right-click a number in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.