Enhancing a 3-D Chart in Excel 2007
10 of 12 in Series: The Essentials of Working with Charts in Excel 2007
Excel 2007 includes several options for enhancing 3-D charts, such as changing the rotation and perspective and using 3-D options that format the chart border. These and other related options can be found on the 3-D Rotation and 3-D Format tabs of the Format Chart Area dialog box.
Follow these steps to enhance a 3-D chart:
Click anywhere on the 3-D chart you want to modify.
Click the 3-D Rotation button in the Background group on the Chart Tools Layout tab.
The Format Chart Area dialog box appears. The options you see depend on the chart type.Use the 3-D Rotation settings to rotate a three-dimensional chart.
From the 3-D Rotation tab settings:
Click the Presets button (if available) to select a built-in rotation or perspective effect.
Click the x-axis left or right rotation arrows or enter the degree of left/right rotation (between 0 and 360) you want for the chart in the Rotation box. This rotates the chart area left or right.
Click the y-axis up or down rotation arrows or enter the degree of up/down rotation.
Click the Perspective up or down arrows to change the camera view or the view from the top.
From the 3-D Format tab settings:
Select a Bevel style for the top or bottom of the chart border.
Use the Width and Height boxes to change the width or height of the top or bottom edge.
The chart appears on-screen, rotated to the angles you selected.A 3-D pie chart before and after enhancement.