Excel - Unveiling the Deception: How Cone & Pyramid Charts Misrepresent Data in Excel - Episode 448

3,998 views · Published 9 June 2009 · 2:14 · Indexed 28 October 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Unveiling the Deception: How Cone & Pyramid Charts Misrepresent Data in Excel.

Welcome back to the MrExcel netcast! In our last episode, we discussed how 3D perspective on a pie chart can be used to manipulate data. Today, we're going to dive into another deceptive chart type - cone and pyramid charts.

Whenever you see someone using these types of charts in a presentation, it's a red flag that they may be trying to hide something. To demonstrate this, we have a simple data set showing the expenses of a non-profit organization. 50% goes towards research, 15% towards grants, and 35% towards administration. However, if we create a standard column chart, we can clearly see that the administration expenses are quite high.

But, if we change the chart type to a cone or pyramid chart, the data is severely misrepresented. The category closest to the bottom appears much larger, while the one closest to the top becomes narrow. This can be used to downplay certain expenses and make them seem insignificant. For example, if someone wants to justify the high administration expenses, they may use a cone or pyramid chart to make it seem like a small portion of the overall expenses.

So, which chart would you rather use to explain the expenses of this non-profit? The one on the left clearly shows the high administration expenses, while the one on the right makes it seem like a minimal amount. And to make matters worse, the title of the chart on the right could even say "Expenses are minimal" and most people would not question it.

Next time you're in a presentation and you see someone using a cone or pyramid chart, stop and think about it. They may be trying to misrepresent the data. Thanks for tuning in to this netcast from MrExcel. See you next time for more tips and tricks on Excel!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Another popular way for people to lie with charts is to use a cone or pyramid chart. Episode 448 shows why your radar should go up anytime you see someone presenting data using these chart types.

This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy and Charts and Graphs for Microsoft Office Excel 2007. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the books!

Table of Contents:
(00:00) Introduction
(00:14) Misrepresentation of data with 3D pie charts
(00:24) Discussion on cone and pyramid charts
(00:37) Example of a non-profit's spending data
(00:47) Comparison of standard column chart and cone/pyramid chart
(01:12) Severe misrepresentation of data with cone/pyramid charts
(01:24) Choosing the appropriate chart to represent data
(01:35) Adding a misleading title to the chart
(01:45) Warning against the use of cone/pyramid charts
(01:55) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial

This video answers these common search terms:
3D perspective on pie chart
Administration block in chart
Beware of cone and pyramid charts
Chart size adjustment
Comparison of charts for administration expenses
Cone and pyramid charts
Expenses, grants, and administration
Explaining high administration expenses
Misrepresentation of data
Misrepresentation of data with cone and pyramid charts
Non-profit spending breakdown
Standard column chart
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152458/

More from this channel