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:

  1. Click anywhere on the 3-D chart you want to modify.

  2. 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.
    Use the 3-D Rotation settings to rotate a three-dimensional chart.
  3. 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.

  4. 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.

  5. Click Close.

    The chart appears on-screen, rotated to the angles you selected.

    A 3-D pie chart before and after enhancement.
    A 3-D pie chart before and after enhancement.
blog comments powered by Disqus

SERIES
The Essentials of Working with Charts in Excel 2007

Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.