Most valuable professional
  • Excel Book Excerpt

Excel Avoid 3-D Chart Types

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Avoid 3-D Chart Types

Problem: I like the look of 3-D chart types, but they don’t seem to be accurate.

Strategy: 3-D chart types are not accurate, so you should try to avoid them. The 3-D effect usually ends up introducing errors into the chart.

Have you ever taken a photography class? The problem with a wide-angle lens is that anything in the foreground appears unusually large. 3-D pie charts have the same problem. The wedges at the front of the chart get more pixels than the wedges at the back of the chart. For example, both charts below are plotting the same data. This organization is spending 34% of its budget on administration. If you are the scientific review board, trying to argue that the administration slice is too large, rotate it around to the front, as in the bottom chart. In the bottom chart, 155% more pixels appear in the administration slice than in the research slice.


Figure 1019 Wedges at the front of a 3-D pie appears unrealistically large.

3-D column charts are not accurate, either. In the top chart below, you can see that each column is above a nearby gridline. Turn that chart into a 3-D column chart, and none of the columns actually extend to the neighboring gridline. People wonder if they should look at the front or the back of the column. I say it doesn’t matter because neither the front nor the back reach to the gridline.


Figure 1020 The 3-D columns don’t reach the gridlines.

You should never use cone or pyramid charts. The categories at the top of each cone get far fewer pixels than the categories at the bottom. In the next figure, the 34% spent on administration seems practically nonexistent.


Figure 1021 Never use cone or pyramid charts.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel: & related websites debuted on November 21, 1998. provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations. This site contains affiliate links. Any affiliate commissions that we earn when you click a link to Amazon or other sites is reinvested in keeping and running. You can earn a commission for sales leads that you send to us by joining our affiliate program. View my Privacy Policy.

Excel ® is a registered trademark of the Microsoft Corporation.
MrExcel ® is a registered trademark of Tickling Keys, Inc.

privacy policy