Excel 2010 Just the Steps For Dummies
Book image
Explore Book Buy On Amazon

Excel 2010 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.

After yuo've created a three-dimensional chart, select it and then 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.

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.

Click Close when you've adjusted all the settings. 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.

About This Article

This article is from the book:

About the book author:

Diane Koers owns and operates All Business Service, a software training and consulting business formed in 1988, that services the central Indiana area. Her area of expertise has long been in the word-processing, spreadsheet, and graphics areas of computing. She also provides training and support for Peachtree Accounting Software. Diane's authoring experience includes over 40 books on topics, such as PC security, Microsoft Windows, Microsoft Office, Microsoft Works, WordPerfect, Paint Shop Pro, Lotus SmartSuite, Quicken, Microsoft Money, and Peachtree Accounting. Many of these titles have been translated into other languages, such as French, Dutch, Bulgarian, Spanish, and Greek. She has also developed and written numerous training manuals for her clients.
Diane and her husband enjoy spending their free time fishing, traveling, and playing with their four grandsons and their Yorkshire Terrier.

This article can be found in the category: