PTS Blog

Main menu:

PTS Utilities

Commercial Utilities developed by Peltier Technical Services

Waterfall Chart
Box and Whiskers


 

Excel Books

Books that I own and use while developing in Excel

Subscribe

Subscribe

Site search


Recent Posts

Recently Commented

Popular Posts

Archive


 

Categories


 

Buy me a coffee

If this topic or the blog itself has been helpful, why not support further development by treating me to coffee?


Privacy Policy

Creative Commons License
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Archive for 'Chart Types'

Rock Around The Clock

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2009.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.


My friend Chandoo proposed a chart to show website traffic vs. time of day in Plot your data around the clock [Excel charting idea]. He thought he’d use the analogy of a 12-hour analog chart, and put a bubble at each hour, where the size of the bubble is related to the pageviews during that [...]

Order of Points in XY and Line Charts

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2009.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.


There has been a lot of discussion here lately about XY and Line charts:

Line Charts vs. XY Charts
Line-XY Combination Charts
Category Axis Tricks for Line and Area Charts - 1
Category Axis Tricks for Line and Area Charts - 2

One interesting thing about a line chart with a date scale X axis is the order of the [...]

In-Cell Bullet Charts

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2009.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.


Stephen Few of Perceptual Edge introduced the concept of Bullet Graphs a few years ago, and their use as a replacement for various gauge charts is slowly expanding. Bullet graphs are easier to read than the many gauges that adorn poorly designed business dashboards, while taking up less space and breaking the ineffective metaphor of [...]

California Majority Party by County

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2009.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.


Nathan Yau of FlowingData asks Can You Improve this Mediocre Statistical Graphic?

So what’s wrong with this chart?

A Gauge that Works?

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2009.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.


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

Chart Selection Guide

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2009.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.


In Chart Rules, As Simple as Possible, But Not Any Simpler!, More Information per Pixel! (the blog of XLCubed, the BonaVista Systems - MicroCharts parent company) has posted some comprehensive chart type selection guidelines, to follow up the recent brouhaha over pie and bar charts. It’s not inappropriate to repurpose a quotation from Einstein, because [...]

Peltier Goes Bar Hopping

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2009.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.


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 © 2009.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.


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

On Seth Godin on Charts

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2009.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.


In The three laws of great graphs, Seth Godin gave these three laws for great graphs:
1. One Story
2. No Bar Charts
3. Motion

In Bar graphs vs. Pie charts, Seth further explains his comments about bar charts:
[T]he purpose of a chart or graph is to make one point, vividly.

I commented on Seth’s three laws in [...]

Bar graphs vs. Pie charts

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2009.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.


The three laws of great graphs contains Seth Godin’s guidelines for charts used in presentations:
1. One Story
2. No Bar Charts
3. Motion

In Seth’s Three Laws of Great Graphs, I agreed in principle, but suggested changing item 2 to “Choose Chart Types Intelligently”, because bar charts are not intrinsically worse than any other chart type.
In [...]

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