Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

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.
  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!