Archive for 'Example Charts'
Show Uncertainty in Predictions with Shaded Bands
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
A reader emailed me this chart of GDP, with actual values through late 2008 and projected values for the next two years. To illustrate the uncertainty in the predictions, colored bands were drawn alongside the solid line prediction. The bands become lighter as the distance from the prediction line increases. The reader wondered how to [...]
Posted: Thursday, April 2nd, 2009 under Example Charts.
Comments: 11
Marimekko Replacement – 2 by 2 Panel
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
I recently posted a tutorial showing how to construct Marimekko Charts in Excel.
Based on Stephen Few’s earlier analysis of Marimekko Chart in A Design Problem, I followed up with The Problem with Marimekkos, in which I showed a couple of approaches to charting the same data, partly based on a multiple bar chart approach proposed [...]
Posted: Thursday, March 5th, 2009 under Example Charts.
Comments: 6
Marimekko Replacement – Overlapping Bars (Hard)
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
In Marimekko Replacement – Overlapping Bars (Easy) I showed a quick and dirty way to make an overlapping bar chart that used only bar length, not rectangle length, width, and area, to encode values. The “easy” method in that tutorial was limited in that the data needed to be symmetric (equal numbers of rows and [...]
Posted: Wednesday, March 4th, 2009 under Example Charts.
Comments: none
Marimekko Replacement – Overlapping Bars (Easy)
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
I showed an overlapping bar chart alternative to a Marimekko chart in my recent post The Problem with Marimekkos. I gave very few clues about how to construct such a chart, so now I’m showing the protocol.
The approach shown here is somewhat simplified, and works only when the grid is symmetrical, with the same number [...]
Posted: Tuesday, March 3rd, 2009 under Example Charts.
Comments: 8
Marimekko Charts
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
This tutorial shows how to create Marimekko Charts, including the specialized data layout needed, and the detailed combination of chart series and chart types required. This manual process takes time, can be prone to error, and becomes tedious.
I have created the Peltier Tech Marimekko Chart Utility to create such charts automatically from raw data. This [...]
Posted: Tuesday, February 17th, 2009 under Example Charts.
Comments: 36
How to Build a 2×2 Panel Chart
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
Several months ago, in Column Chart to Replace Multiple Pie Charts I showed how a column or bar chart could display a table of data more effectively than four pie charts could. Another alternative is to build a panel chart, a shown above.
Posted: Monday, November 24th, 2008 under Example Charts.
Comments: 16
Better Charts of Graduation Rate and Federal Spending
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
In Graduation Rate and Federal Spending [Chart Reviews] Tony Rose of Support Analytics and DSA Insights shows two charts from Business Week.
Federal Spending on Education and Training
The first compares two years of Federal education spending data using side by side pie/donut charts, which commits two sins: using one pie/donut charts, and using more than one [...]
Posted: Tuesday, November 18th, 2008 under Example Charts.
Comments: 12
Conditional Stacked Clustered Column Chart with Targets
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
In the microsoft.public.excel.programming newsgroup, ptheese asked for the following:
I need to chart three groups of two bars on a axis.
-Each group is a year, 2007, 2006, 2005 etc so we can compare data from previous years
-in each group of two there is a profit vertical bar and a combined ratio percentage bar, these [...]
Posted: Monday, February 18th, 2008 under Example Charts.
Comments: 2

















