Peltier Technical Services, Inc.
 

Custom Solutions | Commercial Utilities | Training | Charts and Tutorials | PTS Blog


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

 

 

Books at Amazon.com

 

Buy me a coffee

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

 

Graphical Equity 1.

I've prepared this page as a response to the Graphical Equity 1 blog entry in Kaiser's Junk Charts blog.

Kaiser shows a network diagram and a Marimekko chart that display the 2005 source and usage of energy in the U.S. The network diagram is effective at showing relationships between source and usage, but rather poor at showing quantitative information. The marimekko chart shows the quantitative information graphically, but its columnar alignment gives greater emphasis to one variable (source) at the expense of the other (usage).

To address this shortcoming in a relatively simple way, one can insert two pseudo-categories for source. The first produces a blank stripe at the right of the main chart, the second another set of stacked rectangles, scaled to provide the totals for the unemphasized variable (usage). The very quickly hacked together example below shows this technique:

This chart type can be produced in Microsoft Excel using the technique described in this article:

Matrix Chart (http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=508)

 

 

Page copy protected against web site content infringement by Copyscape

 

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.


Peltier Technical Services, Inc.

Custom Solutions | Commercial Utilities | Training | Charts and Tutorials | PTS Blog

Peltier Technical Services, Inc., Copyright © 2009. All rights reserved.
You may link to this article or portions of it on your site, but copying is prohibited without permission of Peltier Technical Services.

Microsoft Most Valuable Professional

Microsoft Most Valuable Professional

My MVP Profile