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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:37
Excel - Enhance Your Excel Charts: Add a Picture as a Background in Excel - Episode 917
-
2:00
Excel Hiding Data in Plain Site - Episode 919