To change a chart area in Excel, select the chart, right-click its outer background, choose Format Chart Area, then adjust the fill or border in the formatting pane. To change its size, select the chart and drag an outer sizing handle. These edits affect the chart’s overall background or dimensions; the plot area inside it can be formatted separately.
What You’ll Need
- A workbook containing a chart. If you do not have one yet, select your data and choose Insert followed by a chart type.
- Excel for Microsoft 365 on Windows for the ribbon paths below. Excel for Mac has similar formatting controls, while Excel for the web may offer fewer options.
- If the chart is important, save a copy of the workbook first, especially before making several appearance changes.
Step-by-Step
- Select the chart. Click once on the chart’s outer edge or on an empty part of its background. A border with sizing handles should appear around the whole chart, and the contextual Chart Design and Format tabs should show on the ribbon. If you see selection handles around only one bar, label, or other element, press Esc and click the chart background again.
- Make sure you have selected Chart Area. Right-click an empty part of the chart background, away from the bars, lines, title, legend, and gridlines, then choose Format Chart Area. Alternatively, select the chart, open the contextual Format tab, and use the Current Selection dropdown to choose Chart Area. The pane should identify the selected element as Chart Area. This matters because the plot area is a different part of the chart.
- Open the fill controls. In the Format Chart Area pane, select the Fill & Line icon, usually shown as a paint bucket. Expand Fill if its options are collapsed. Depending on your Excel build, you may see options such as No fill, Solid fill, Gradient fill, Picture or texture fill, or Pattern fill. For a straightforward background color, choose Solid fill.
- Choose a background color. Open the Color control and pick a theme color, standard color, or another available color. Use a light, low-contrast shade if the chart contains dark text or fine gridlines. If you want the worksheet cells behind the chart to show through, select No fill instead. The chart area may then appear to have no background, even though the chart remains in place.
- Adjust transparency or use a gradient if appropriate. With Solid fill selected, use the Transparency setting to make the color more or less see-through. A fully opaque fill covers the worksheet behind the chart; a more transparent fill lets some of it show through. If you select Gradient fill, choose a preset or adjust the gradient stops and direction available in the pane. Keep effects restrained so the data, labels, and legend remain easy to read.
- Set or remove the chart-area border. In the same Fill & Line pane, expand Border. Choose Solid line to add an outline, then select its color, width, and any available dash style. Choose No line to remove the outline. A subtle border can separate a chart from a busy worksheet; a thick or brightly colored border can draw attention away from the data.
- Resize the chart. Close the formatting pane if it blocks the chart. Click the chart’s outer boundary, then drag a corner handle to change its height and width together, or drag a middle handle to change one dimension. Keep the proportions sensible: a chart made too wide or too short can compress labels or make the plotted data difficult to interpret. For a specific size, select the chart and look for the Height and Width boxes in the contextual Format tab’s Size group.
- Review the result and keep the edit. Click a blank worksheet cell to see the chart without selection handles. Check that the fill, border, title, legend, labels, and data are all legible. Save the workbook when you are satisfied. To reverse a recent change, use Undo; if you want to remove just the background color, reopen Format Chart Area and choose No fill.
To change only the inner plotting region: select the chart, then click inside the rectangle containing the data marks and gridlines. Right-click and choose Format Plot Area. Its fill and border controls are similar, but the edit applies to the plot area rather than the overall chart background. Chart titles, legends, and axes sit in the chart area but outside the plot area, so changing one does not automatically format the other.
Common Mistakes
- Formatting the plot area by accident. Clicking near the data marks may select Plot Area instead of Chart Area. Check the name at the top of the formatting pane, or choose Chart Area from the Format tab’s Current Selection dropdown before changing the fill.
- Selecting a chart element instead of the background. A title, legend, axis, or data series can be selected independently. If the pane shows a different element name, do not assume your background change will affect the whole chart. Reselect Chart Area.
- Expecting No fill to mean white. No fill makes the chart area transparent, so worksheet content or the sheet background can show through. Choose a solid white fill if you need a white background for printing or placing the chart on a colored sheet.
- Changing chart size when you meant to resize the plot. Dragging the chart’s outer handles changes the overall chart dimensions. If the goal is more room for the data region while retaining the chart’s outer size, select and adjust the plot area instead.
- Using strong effects that reduce readability. Dark fills, high transparency, heavy outlines, and decorative gradients can make labels hard to read. Check the finished chart at its intended on-screen or printed size.
Tips
- Use the theme palette for consistency. Theme colors are more likely to coordinate with the workbook’s fonts and other charts than an arbitrary color. A neutral chart background is often a safe choice when the data series already use several colors.
- Format Chart Area and Plot Area separately. A light chart background with a slightly different plot-area fill can distinguish the data region without adding a visible frame. Make sure the plot fill does not compete with gridlines or series colors.
- Keep enough space for titles and legends. If a title or legend looks crowded after resizing, adjust the overall chart dimensions or reposition the element rather than shrinking text until it is difficult to read.
- Use alignment guides when arranging charts. When you drag a chart on a worksheet, Excel may display alignment guides to help line it up with cells or other objects. For dashboards, consistent chart widths and spacing make the sheet easier to scan.
- Consider how the chart will be shared. A transparent chart can blend into a worksheet, but may look different when copied to another document or placed on a different background. A solid fill is more predictable when the chart will be printed or reused elsewhere.
- Use the Mac or web controls where applicable. In Excel for Mac, select the chart and use the contextual Format tab or right-click the chart area to open its formatting options; names and pane layout can vary slightly by release. Excel for the web supports basic chart formatting, but if a control or detailed fill option is missing, open the workbook in the desktop app.
Troubleshooting
The formatting pane does not open: First select the chart, then right-click an empty part of its background and choose Format Chart Area. If a right-click menu for a title, series, or plot area appears, click a different blank spot or select Chart Area through Format > Current Selection. On a trackpad, use the equivalent secondary-click gesture.
The fill change affects only the inner rectangle: You likely selected Plot Area. In the pane, confirm the selected element’s name. Then use the Current Selection dropdown to select Chart Area and repeat the fill change. If you intended to color only the region behind the data, keep the Plot Area selection instead.
The background color seems to disappear: Check whether No fill is selected, or whether the fill transparency is set very high. Choose Solid fill, select a visible color, and reduce transparency. Also click outside the chart: selection outlines and handles can make a subtle border or fill harder to judge while editing.
The chart will not resize as expected: Confirm that the chart, rather than an individual chart element, is selected. Drag a handle on the outer chart boundary, not a handle around the plot area or a text box. If the chart is on a protected sheet, or the object is locked, you may need permission to edit it or to unprotect the sheet before resizing.
Some options are missing: The formatting controls vary between desktop Excel and Excel for the web, and can also differ slightly between releases. Try selecting the chart first, then check the contextual Format tab. For detailed line, gradient, or size controls that are unavailable in the browser, open the workbook in Excel for Microsoft 365 on Windows or Excel for Mac.
Frequently Asked Questions
What is the chart area in Excel?
The chart area is the overall chart region, including the plot area and elements such as the title, legend, and axes. The plot area is the inner region where Excel displays the data marks and gridlines.
How do I change the chart background to white?
Select Chart Area, open Format Chart Area > Fill & Line > Fill, choose Solid fill, and select white. This creates a white background rather than a transparent one.
How do I make a chart area transparent?
Select Chart Area, open its fill options, and choose No fill. If the chart still looks colored, check whether you selected Plot Area, which may have its own separate fill.
Can I change the chart area without changing the plot area?
Yes. Select Chart Area and format it separately from Plot Area. Each can have its own fill and border, so you can use different colors or remove the fill from one while keeping it on the other.
Can I set an exact chart size?
Yes. Select the chart and enter measurements in the Height and Width boxes in the contextual Format tab’s Size group. If you cannot see those boxes, widen the Excel window or look for a collapsed ribbon group.
Related
- Add a White Background and One Border in Excel
- How to Adjust Zoom Level in Excel
- How to Add a Tick Box in Excel: A Step-by-Step Guide
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Stacked Bar Chart: Change Series Order EasilyTo change the series order in an Excel stacked bar chart, select the chart and choose Chart Design…
- Excel Area Chart: How to Create and Format OneTo create an area chart in Excel for Microsoft 365 on Windows, select your data, then choose Insert…
- Does Excel Have an Org Chart? How to Create OneYes. Microsoft Excel for Microsoft 365 includes an org chart option in SmartArt: select Insert > SmartArt >…
- Excel Line Chart: How to Add a Vertical Reference LineTo add a vertical line to an Excel line chart, use Insert > Shapes > Line for a…
- Automated Gantt Chart in Excel: Setup and LimitsYes. In Microsoft Excel for Microsoft 365 on Windows, you can make a Gantt chart update automatically by…
- Excel Chart With Two Different Scales: How to Make OneYes. In Excel for Microsoft 365 on Windows, put one data series on a secondary axis: select the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.