Using the Depth Axis in Excel 2007:-


One element unique to surface charts is the depth axis. This is the axis that falls along the right side of the chart in the default orientation.

In the top-right chart in the Figure (given below), the chart has been turned around by having the orientation of the depth axis changed. You follow these steps to create this effect:

1. From the Layout ribbon, choose Current Selection, Depth (Series) Axis.

2. Click Format Selection.

3. Choose Series in Reverse Order.

Because the depth axis is treated as a category axis, you do not have control over the minimum or maximum values along the axis. The Format dialog box is limited to settings for the interval between tick marks and labels and where the tick marks and labels appear.



(All four charts represent the same data. Each chart provides a different view angle.)