Formatting 3-D chart elements
Excel has two types of 3-D charts. Some 3-D chart types, like the 3-D clustered column, display
the data series using a 3-D effect. These are not true 3-D charts. A true 3-D chart adds a third
dimension showing depth. Use a 3-D chart, like the 3-D column or 3-D cylinder, to compare data
across both the horizontal axis (x axis) and depth axis (z axis).
3-D charts include chart elements that other charts do not have: back wall, side wall, floor, floors
(to format the back wall and side wall at the same time), and depth (series) axis. You can change
the fill, border, and other formatting aspects as you would with other chart elements.
Format Chart Area
dialog, you can modify the overall 3-D appearance of the chart.
drop-down list on the Ribbon to select the chart area, or right-
click an empty part of the chart area and select
Format Chart Area.
section, increase or decrease the angle of each individual axis to rotate the
chart or modify the overall perspective. As you make selections, Excel changes the chart
section, use the
Depth (% of base)
option to control the depth of the
chart. Decreasing the depth of the base shortens the chart floor; increasing the depth of
base lengthens the chart floor.
Notice that as you make selections in the
Format Data Series
dialog, Excel applies them
to the chart. To undo the changes, close the dialog and use the