PTS Blog

Main menu:

Excel Books

Books that I own and use while developing in Excel

Goods and Services

Excel or charting related products and services which I use or feel are worthwhile additions

Excel User Conference

2008 US East Coast Excel User Conference
September 24-26, 2008
Atlantic City, NJ

Subscribe

Site search


Recent Posts

Recently Commented

July 2008
S M T W T F S
« Jun    
 12345
6789101112
13141516171819
20212223242526
2728293031  

Archive


 

Categories


 

Archive for 'Bad Charts'

A Gauge that Works?

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

In A Gauge Chart That Works?, Clint describes his efforts to come up with a dial-type chart that isn’t as terrible as most. He comments that Stephen Few’s Bullet Graphs are unfamiliar to most people, which is true, ans they’ve only been around for three or four years. Bullet graphs and most gauge-type charts are [...]

Peltier Goes Bar Hopping

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

There has been a lot of discussion about pie charts and bar charts lately. I and many other know-it-alls have clearly stated that pie charts are the red-headed stepchildren in the family of chart types. In Peltier Loves Pie I provided some guidelines to follow if you still insist on using pie charts.
In this post [...]

Peltier Loves Pie

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

Cynthia makes a mean cranberry-apple pie, and also a black bottom pie featuring a chocolate cookie crust, layers of chocolate and eggnog flavored pudding, and whipped cream. So you could accurately say that Peltier Loves Pie. But not pie charts.
There has been a lot of discussion about pie charts and bar charts lately. See for [...]

Ineffective Chart - Partition Chart Revisited (Defragged)

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

In Ineffective Chart - Partition Chart, I discussed the partition chart that Chandoo spoke of in Partition Charts in Excel - alternative to pie charts [visualization hack]. I felt that the partition chart hid the data it was meant to present. Jorge Camoes remarked that it looked to him like the map of a fragmented [...]

Re: Graphical Propaganda

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

In More graphical propaganda, Andrew Gelman of the Statistical Modeling, Causal Inference, and Social Science blog shows some pie charts of recent Kenyan election results which he got from John Sides’ blog post, Election Fraud in Kenya in The Monkey Cage blog. The charts are awful; as Andrew notes, the colors change and the [...]

Ineffective Chart - Partition Chart

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

In Partition Charts in Excel - alternative to pie charts [visualization hack], Chandoo offers a “partition chart” as an alternative to a pie chart. We all know pie charts are bad (don’t we???), so it’s good to look for alternatives. Here is part of Chandoo’s partition chart:

This chart uses conditional formatting to achieve the mottled [...]

Bad Graphics - Funnel Chart

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

In Bad Graphics - Stacked Pyramid Chart, I critiqued a popular infographic display type, the pyramid chart. In this post I will repeat the favor for funnel charts. These are not the funnel charts which are also called tornado charts, and in some circles are used to construct population pyramids (see Tornado Charts and Tornado [...]

Bad Graphics - Stacked Pyramid Chart

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

I was directed to the web site for UberBI after reading The Uber Art of Dashboards on the Dashboards by Example blog. I want to say a few words about this chart, a stacked pyramid, which is featured prominently on one of UberBI’s displays.

Stacked Pyramid Chart
I occasionally read the Dashboards by Example blog, although I [...]

The Perils of Being in 3D

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

Whenever I am faced with a 3D chart I think of the song lyric I’ve used as the title of this post, taken from Pardon Me by Incubus. I also think of the following chart, which was submitted by thiswasmyclone to the b3ta challenge: graphs. (I didn’t add a hyperlink, because I didn’t want to [...]

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