Microsoft Office Tutorials and References
In Depth Information
Formatting a surface chart
Figure 4-41: The 3-D View dialog box
enables you to rotate and change the
perspective of a 3-D chart. You also can
drag the chart with the mouse.
Formatting a surface chart
A surface chart is different from the other chart types because you cannot select
any of the series in the chart. Another difference is that the colors in the chart are
based on the values.
The number of colored bands used in the chart depends on the major unit setting
for the value axis. Figure 4-42 shows two surface charts. In the chart on the left, the
value axis major unit is 0.05 (the default). In the chart on the right, the value axis
major unit is 0.4, which covers the entire scale for the chart. Consequently, this
chart displays a single color.
The procedure to adjust the colors used in a surface chart is rather counter-intuitive.
First, you need to make sure that the chart displays a legend. Next, click the legend to
select it and then double-click the color key that you want to change. This displays the
Format Legend Key dialog box. Use the Patterns tab to change the color. The Options
tab of this dialog box enables you to change the depth of the chart, as well as apply
3-D shading to the chart — an option that can make the chart look much better.
Figure 4-42: Changing the major unit for the value axis controls the number of colors
used in a surface chart.
Search JabSto ::




Custom Search