In Excel, a side wall is a background plane on a three-dimensional (3-D) chart; an ordinary two-dimensional (2-D) column chart has no side wall. To show or format one, change the chart to a 3-D column type, select the wall, then use the chart’s Format Selection pane to adjust its fill, line, or effects.
What the Side Wall Is
A chart’s side wall is part of the 3-D setting that gives a chart depth. It appears behind the data, alongside the plot area, and can help make the chart look like a three-dimensional scene. Depending on the chart’s viewing angle, the visible side wall may appear on the left or right. The chart may also show a back wall and a floor beneath the columns.
These are chart background elements, not data series. Changing a wall’s color does not alter the values, category labels, or column formatting. It changes only the visual surface behind the data.
This distinction matters because Excel’s standard 2-D column charts do not have walls. They have a chart area, which is the full chart container, and a plot area, where the columns, axes, and gridlines appear. Formatting either of those areas will not add a side wall. If a guide or colleague refers to a “side wall” on a flat column chart, they may mean the plot-area background or may be looking at a 3-D chart.
How to Find the Side Wall
First check whether the chart is actually three-dimensional. Click the chart and look at the chart type, or inspect it visually: a 3-D column chart shows depth on the columns and usually has visible background planes. If the columns are flat rectangles with no depth, it is a 2-D chart and there is no side wall to select.
In Excel for Microsoft 365 on Windows, you can select the wall directly if it is visible, or use the chart-element selector:
- Click the chart to show the chart-specific ribbon tabs.
- Open the Format tab (sometimes labeled Chart Format) and locate the Current Selection group.
- Open the Current Selection list and choose Side Wall if it is available.
- Choose Format Selection to open the formatting pane.
Another option is to right-click the visible wall and choose Format Walls or the equivalent wall-formatting command shown in the context menu. Clicking a chart element can be imprecise, especially when the wall is narrow or partly covered by columns. The Current Selection list is often the easier route. Its entries depend on the chart type and the elements Excel makes available for that chart.
How to Make a 3-D Column Chart
If your chart is currently 2-D and you specifically need a side wall, change its chart type. Select the chart, then choose Chart Design > Change Chart Type. In the dialog, choose Column and select a 3-D column option, such as 3-D Clustered Column, then confirm. The exact choices displayed depend on the chart and Excel version.
You can also create a new chart by selecting the source data and choosing Insert > Insert Column or Bar Chart, then selecting a 3-D column option from the menu. For a chart with one series per category, a 3-D clustered column chart is a common starting point. If the goal is to show values as parts of a total, check whether a 3-D stacked chart is appropriate, but keep in mind that perspective can make comparisons harder.
After changing chart type, inspect the labels, axis scale, and series order. A 3-D version may use a different perspective, and categories at the back can appear smaller or less prominent. Switching to 3-D changes the presentation, not the underlying worksheet values.
Formatting the Wall
Once Side Wall is selected and the Format Selection pane is open, look for the formatting controls available for that chart element. Typically, the pane lets you set a solid fill or a gradient, adjust transparency, and change the border line. Some chart elements also offer effects such as shadows or soft edges. The precise controls can vary with the chart type and Excel build.
A restrained wall treatment is usually easiest to read. A light neutral fill can separate the background plane from the chart area without competing with the columns. A strong border may make the wall look like a box, and a dark or saturated fill can reduce contrast with axis labels or data markers. If the chart is intended for printing, check its appearance in print preview because pale fills and subtle borders may reproduce differently on paper.
Formatting the wall is separate from formatting the columns. To change a column’s fill, select a data series or an individual data point instead. If the wrong pane appears, close it, select the wall again through Current Selection, and reopen Format Selection. The pane heading should identify the selected element; that heading is a useful check before making changes.
Side Wall, Back Wall, Floor, and Plot Area
Several chart elements can look like a background surface, so it helps to identify the one you intend to edit:
- Side wall: A side plane in a 3-D chart, visible to one side of the plot depending on the viewing angle.
- Back wall: The rear plane behind the plotted data. It may carry axis lines or gridlines.
- Floor: The horizontal base plane under the columns in a 3-D chart.
- Plot area: The region where data is plotted. It exists in both 2-D and 3-D charts.
- Chart area: The overall chart container, including the plot area, title, legend, and other chart elements.
When you select an element, use its name in the Current Selection list or the formatting pane to confirm you have the right one. A wall and the plot area can overlap visually, but they are distinct elements and may expose different formatting controls.
When a Side Wall Is Missing or Hard to Select
If you cannot find a Side Wall entry, the chart may be 2-D, or the selected chart type may not expose that wall as a separately selectable element. Confirm the chart type through Chart Design > Change Chart Type. If it is already a suitable 3-D chart, try selecting the wall in the Current Selection list rather than clicking the chart itself.
Other common causes of confusion include:
- The plot area is selected: Check the selection name in the Format pane and choose Side Wall again.
- The wall is obscured: Columns, labels, or a tight viewing angle can make the surface difficult to click. Use the selection list.
- The chart has no visible wall: The wall may blend into the chart background or be hidden by the current layout. Try a temporary contrasting fill to identify it, then choose a suitable final color.
- The ribbon tabs are not visible: Click the chart once. Chart Design and Format tabs appear when a chart is selected.
- The chart is an image: A pasted picture of a chart is not an editable chart, so its walls cannot be selected as chart elements. Find the original chart or recreate it from the worksheet data.
If Excel for the web or another platform has a different layout, the selection and formatting controls may appear in different places or offer fewer options. The instructions above are for Excel for Microsoft 365 on Windows. On Mac, chart-specific tabs and the Format pane are available, but ribbon labels and placement can differ; use the chart’s Format controls or context menu and confirm the selected element in the pane. Keyboard shortcuts for selecting a particular wall are not consistent, so the element list is more dependable.
Should You Use a 3-D Column Chart?
A side wall is a styling feature, not a requirement for a column chart. Three-dimensional perspective can make columns at the back seem smaller than equally valued columns near the front, and it can make heights harder to compare against the axis. A colored wall may add depth, but it does not make the values more accurate or the chart easier to interpret by itself.
For most comparisons, a 2-D clustered column chart is clearer. It gives each column a consistent, direct relationship to the value axis and avoids perspective effects. Consider a 3-D chart when depth is genuinely useful for the presentation or when a particular visual style is required, and verify that viewers can still compare the values accurately. If precise comparison is the priority, retain a 2-D chart and format its plot area instead of trying to add a wall.
Practical Design Tips
Keep the wall subordinate to the data. Use a fill with enough contrast to distinguish the background planes, but not so much that it competes with the columns. Avoid using a different bright color on every plane unless there is a clear reason; multiple strong surfaces can make the chart look crowded.
Check the final chart at the size readers will see it. A wall that looks subtle on a large monitor might dominate a small report or slide. Also check text contrast, axis readability, and whether gridlines remain visible. If the chart will be printed in grayscale, use more than color alone to distinguish important information, and review a print preview or test print.
Finally, preserve the underlying data and make sure the chart type suits the message. A visually polished 3-D chart can still mislead if its perspective disguises differences. When the side wall is only decorative, ask whether the chart communicates just as well without it.
Frequently Asked Questions
Can I add a side wall to a 2-D column chart?
No. A standard 2-D column chart has a chart area and plot area but no 3-D wall. Change it to a suitable 3-D column chart if you need walls, or format the plot area if you only want a colored background.
How do I change the side wall color in Excel?
Select the 3-D chart, choose Side Wall from Format > Current Selection, and click Format Selection. In the pane, adjust the wall’s fill and, if needed, its border. The available options can vary by chart type.
Why can’t I select the side wall?
The chart may be 2-D, the wall may be obscured, or you may have selected the plot area instead. Check Chart Design > Change Chart Type, then use the Current Selection list to choose Side Wall if it is offered.
Is the side wall the same as the plot area?
No. The plot area is where the data is drawn and exists in 2-D and 3-D charts. The side wall is a background plane associated with a 3-D chart.
Can I remove the wall but keep the 3-D columns?
Depending on the chart and available formatting controls, you may be able to set the wall fill and border to no fill or no line. If those controls are unavailable or the result remains visually busy, use a 2-D chart for a cleaner view.
Does a side wall change the chart’s data?
No. It changes the chart’s appearance only. The worksheet values and plotted series remain the same unless you separately edit the source data or chart settings.
Related
- Quick Schedule Maker in Excel: Build One Fast
- Excel Strikethrough Shortcut: Quick Key and How to Use It
- Subscript in Excel: Shortcut and Formatting Steps
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Waterfall Chart End Value: Set the Final TotalTo make the last bar in an Excel waterfall chart show the ending balance, right-click that bar and…
- Excel Chart: Add a Data Label to the Last PointTo label only the last point in an Excel chart, click the data series once, click its final…
- How to Add a Trendline to an Excel Clustered Column ChartIn Excel for Microsoft 365 on Windows, select the clustered column chart, then choose Chart Design > Add…
- Add a Histogram in Excel: Create, Format, and Read ItTo add a histogram in Excel for Microsoft 365 on Windows, select one column of numeric data, then…
- Creating a Sunburst Chart in Excel: Step-by-StepTo create a Sunburst chart in Excel for Microsoft 365 on Windows, arrange your data in columns from…
- Pivot Charter School: How Its California Model WorksPivot Charter School refers to California public charter schools associated with a flexible, personalized learning model, commonly built…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.