PTS Blog

Main menu:

PTS Utilities

Commercial Utilities developed by Peltier Technical Services

  Waterfall Chart

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

Subscribe

Site search


Recent Posts

Recently Commented

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

Archive


 

Categories


 

Archive for Thursday, July 10th, 2008

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 [...]

Line Charts vs. XY Charts

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

In Line-XY Combination Charts I showed how to make a combination Line-XY chart. It is probably important to discuss the differences between line charts and XY charts. The documentation is not clear, and the names of the chart types are not helpful; in fact, they lead to confusion.
The icons in the Chart Type dialog and [...]

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