Microsoft Office Tutorials and References
In Depth Information
To make your chart more readable, you may want to
change some of the attributes of your chart. You can
easily change the walls and floor of your
threedimensional charts. The walls are the side and back
of your chart and the floor is the bottom of your
chart. You can choose to show the chart walls and/or
floor; fill the chart walls and/or floor with a color,
gradient, or other item; or not show the walls and/or
floor at all.
Excel bases axis values on the range of values in
your data. Axis values encompass the range. Axis
labels describe the data displayed on each axis. Excel
provides several options for choosing whether to
display axis values and how to display the axis values
and labels on each axis, including the horizontal,
vertical, and depth axes.
When you create a chart in Excel, Excel creates
horizontal and vertical gridlines to mark major
intervals in your data series. You can remove the
gridlines, display major gridlines only, display minor
gridlines, or display major and minor gridlines.
C HANGE THE W ALL AND F LOOR
1 Click your chart.
l The Chart tools become
2 Click the Layout tab.
3 Click Chart Wall in the
A menu appears.
4 Click More Wall Options.
l Alternatively, choose an option
from the menu.
l The Format Walls dialog box
Click to choose a fill option
l Excel changes the fill of the chart
l Click Chart Floor in the
Background group and repeat
Steps 4 to 6 to change the