Formatting the Chart Walls and Floor of a 3-D Chart in Excel 2007:-

With a 3-D chart, you can format the chart wall and chart floor instead of the plot area. Drop-downs on the Layout ribbon offer built-in choices to turn on the formatting of either the chart wall or the chart floor. Three different components can be formatted: the back wall, the side wall, and the chart floor.

If you use the Current Selection drop-down on the left side of the Layout ribbon, you can select the floor, back wall, side wall, or walls. Selecting Walls is the same as selecting both the back wall and the side wall. After you have selected an element, you can use the Format Selection button under the drop-down to format the element. As with the plot area, you can specify a solid fill, a gradient, a texture, or a picture.

Figure (given below) illustrates the various elements that can be individually formatted.



(In a 3-D chart, you can format the walls individually or as a single unit.)