Archive for 'Chart Types'
Stacked Bar Chart Alternatives
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
In Gartner’s Customer Survey Results: Customers Using Vendors for BI Activities, Elissa Fink of Tableau presented a stacked bar chart that showed how BI customers use their BI products.
Good first cut through the survey data, perhaps, but stacked charts leave something to be desired. The only common baseline is along the left axis of the [...]
Posted: Wednesday, March 31st, 2010 under Chart Types.
Comments: 48
Area Chart With Gap
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
In Mind the Gap – Charting Empty Cells I showed how the various Excel chart types treat blank cells, through various settings like Leave a Gap, Treat as Zero, and Interpolate.
In that article I wrote:
Area charts seem to offer both the zero and interpolation options, but in both cases, the chart plunges to zero without [...]
Posted: Tuesday, March 23rd, 2010 under Chart Types.
Comments: 4
Charting Breakdown of Ads in a Television Show
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
Dick Kusleika’s a fan of House, and so am I. Last week in Charting House, Dick analyzed the commercial breaks in an episode that he’d recorded for later viewing. Dick’s first cut at the data was a stacked bar chart, which basically tracked the segments of actual show and commercial breaks in sequence through the [...]
Posted: Monday, March 22nd, 2010 under Chart Types.
Comments: 5
Crosstab Heat Map
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
Heat maps are a popular way to display varying values in a two-dimensional display. The heat map may be an actual geographic map with regions colored differently according to some variable, for example, population density or electoral results. I showed such maps, also called cartograms or choropleths, in Redrawn Electoral Maps and An Undistorted Election [...]
Posted: Wednesday, March 17th, 2010 under Chart Types.
Comments: 12
Contour and Surface Charts in Excel 2007
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
Some time ago I wrote about Surface and Contour Charts in Microsoft Excel in Dian Chapman’s TechTrax Ezine. In that article I outlined the data requirements for surface and contour charts, and described some of the formatting idiosyncrasies of these charts. That article was valid for Excel versions 97 through 2003, but like so many [...]
Posted: Tuesday, February 23rd, 2010 under Chart Types.
Comments: 8
Pareto Charts
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
In Pareto lines on bar charts – an Excel fudge, Alex Kerin of Data Driven Consulting took data from a very badly distorted pie chart, and generated a Pareto chart. I busted the pie in Extra Distortion in a Pie Chart, but thought I’d chime in on the subject of Pareto Charts.
A Pareto Chart is [...]
Posted: Monday, February 8th, 2010 under Chart Types.
Comments: 31
Pie Chart Quiz
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
Here’s a quick quiz for all of you aspiring chart experts:
Question
In the chart below, rank the following in decreasing order of value:
Red wedge
Orange wedge
Pink wedge
Sum of four smaller wedges
The real answer may surprise you (or maybe not).
Posted: Friday, December 4th, 2009 under Chart Types.
Comments: 11
You Say “Pie”, I Say “Bar”
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
Chandoo says we can Group Smaller Slices in Pie Charts to Improve Readability. Such a pie has too many labels to fit into a tight space, so you need to move the labels around and use leader lines to link the labels to their data points.
An extreme example? Judging from what I see around the [...]
Posted: Wednesday, December 2nd, 2009 under Chart Types.
Comments: 7
I Keep Saying, Use Bar Charts, Not Pies
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
Has anybody not seen this unique pie chart? This famous graphic is purported to compare Sarah Palin’s favorability to that of Mitt Romney and Mike Huckabee. I have seen it dozens of times already, but I think the first place I saw it was in Fox’s Fuzzy Math: 193 Percent Of The Public Support Palin, [...]
Posted: Tuesday, December 1st, 2009 under Chart Types.
Comments: 15
Exploded Pie Chart Replacement
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
This post was inspired by Moving a Pie Slice, a recent post on Patricia the Excel Diva’s Chatting about Excel blog. Patricia presents a few helpful Excel tips each week.
In Moving a Pie Slice, Patricia shows how to explode one pie segment out of the pie chart. I’ll review the protocol, not because I want [...]
Posted: Wednesday, November 25th, 2009 under Chart Types.
Comments: 6

















