Peltier Tech Blog

Excel Charting Utilities | Custom Solutions | Training | Charts and Tutorials | PTS Blog

 

Main menu:

 
Peltier Tech
Chart Utilities

PTS Waterfall Chart Utility
PTS Cluster-Stack Column Chart Utility
PTS Box and Whisker Chart Utility
PTS Marimekko Chart Utility
PTS Dot Plot Utility
PTS Cascade Chart Utility

Subscribe

Site search

Subscribe

Site search


Recent Posts

Recently Commented

Popular Posts

Archive


 

Categories


 

Buy me a coffee

If this topic or the whole blog has been helpful, support further development by treating me to a cup of coffee.


Privacy Policy

Creative Commons License
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Archive for 'Chart Busters'

Extra Distortion in a Pie Chart

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

148Apps recently treated us to a fancy pie chart in Apple iTunes App Store Metrics, Statistics and Numbers for iPhone Apps which demonstrated how easy it is, if you’re not satisfies with how much a 3D pie chart can distort data, to add extra distortion. If ever there was a job for Chart Busters, this [...]

Dating Site Photo Effectiveness

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Kaiser of JunkCharts has posted twice in a couple days about some charts that compare the effectiveness of different profile photo topics, in terms of attracting a potential date. The article that led to the controversy is The 4 Big Myths of Profile Pictures on a site called OK Cupid. Kaiser posted first in Light [...]

Use Dot Plots for Better Categorical Comparisons

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

In Yikes! Another Pie Horror Show, I was showing problems with yet another pie chart. I know the criticism of pie charts getting tiresome, but I wanted to respond to a comment by Jeff Weir:
Q: What’s worse than comparing categories within a pie chart?
A: Comparing categories between 2 pie charts.
I will use an article [...]

Yikes! Another Pie Horror Show

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

My friend Debra Dalgleish notified me the other day that it was National Pie Day.

I missed National Pie Day, but while reading The Real Reason Outsourcing Continues To Fail, I encountered a pie chart that gave me indigestion. It purports to show problems with inter-cultural relationships that lead to outsourcing failures.

Graphing The Cost of Health Care

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

My friend and colleague John Walkenbach pointed me to a post from National Geographic called The Cost of Care, which compared health care spending with life expectancy for a number of countries. John asked how I would display this data.
The article shows a line chart with a line connecting a country’s health care spending on [...]

Better Chart of the Day

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

I often read the Chart of the Day feature on the Silicon Alley Insider. It’s kind of a pop look at something relevant to the technology industry. The charts are a bit more cerebral and way less chart junkie than those in USA Today, and I like to just have a peek to make sure [...]

Comparison of Search Share, September and October 2009

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

The Marketing Charts blog compared Google to the rest of the world in Online Search Share, September 2009 & October 2009. The “guidelines” were followed: for parts of a whole, use a pie chart. And for comparison, why not two pies side by side?

Well, as Edward Tufte once said, “The only thing worse than a [...]

Misguided “Professional” Charting Tutorial

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

In this edition of Chart Busters, I’ve taken on a charting tutorial on the Microsoft web site. I know they are trying to help their customers make better use of their software, and some of the Microsoft tutorials are really pretty good. They have some helpful pages on using pivot tables, for example. But this [...]

Climate Change Survey Results

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Dustin Smith’s World Opinions on Climate Change article in Chart Porn blog pointed me to an attractive but ultimately ineffective graphic. The road to Copenhagen Summit on Whatype blog presents results of a 2007 World Public Opinion survey of worldwide public sentiment over global warming-related issues. The graphic is reproduced in small size below; click [...]

What’s Worse Than A Pie Chart?

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

A Bar-of-Pie Chart. And a Pie-of-Pie Chart may be even worse. Let the Chart Busters explain.
Last week, Excel guru John Walkenbach conducted a poll on his wildly popular J-Walk Blog asking people to Post Your Pet. The poll results were tabulated in Tabulating The Pets.
I know John’s an expert and all, and he [...]

PTS Waterfall Chart Utility PTS Cluster-Stack Column Chart Utility PTS Box and Whisker Chart Utility PTS Marimekko Chart Utility PTS Dot Plot Utility PTS Cascade Chart Utility

Create Excel dashboards quickly with Plug-N-Play reports.