Dashboard Examples - Samples - Tutorials


Dashboard Digest - Shared Knowledge from all Dashboard Experts

Hello and welcome to the Dashboard Digest. There are so many wonderful digital dashboard related websites (dashboardspy, dashboardinsight, dashboardzone to name a few) including some vendor specific blogs. This website serves to be just a digest for all the dashboard content. If you would like to include your blog as part of this digest please email us a link. (dashboard.kpi"AT"gmail"dot"com).
RSS Subscribe to RSS

Chart Rules, As Simple as Possible, But Not Any Simpler!

In chart design it’s good to make things simple, but you certainly should avoid oversimplification. As Einstein said:

"Things should be made as simple as possible, but not any simpler"

Seth Godin presented in his blog The three laws of great graphs:

1. One Story
2. No Bar Charts
3. Motion

Effective chart design rules are simple, but reducing it to this set of 3 rules certainly is an over-oversimplification.

Particularly rule 2 is flawed. Seth details rule 2:

"NO BAR CHARTS
Bar charts are dramatically overrated, primarily because they’re the first choice in many graphing programs.

The problem with bar charts is that they should either be line/area charts (when graphing a change over time, like unemployment rates) or they should be a simple pie chart (when comparing two or three items at the same scale).

Jorge, Kaiser and Jon already wrote some critical posts about this rule, where Jon suggested to replace rule 2 with

Choose Chart Types Intelligently

We are working tightly together with Stephen Few on a new product that helps business users creating effective charts with Excel and are therefore we are quite familiar with Stephen’s design principles.

Its an easy to learn set of rules

1. Determine the relationship you want to display

Relationship Sample

Value Comparison

Sales in different regions

Ranking

Best selling products

Time-Series

Sales in the last 12 months

Part-to-Whole

Market shares

Deviation

Revenue Actual vs Budget in the last 12 months

Distribution

Support response times

Correlation

Relationship between employee’s heights in inches and their salary

 

2. Determine if you want to emphasize individual values or the overall pattern
3. Determine the chart type

Relationship Encoding Method  

Value Comparison

Bars and Columns

image

Ranking

Bars and Columns

image

Time-Series

Lines to emphasize the overall trends or pattern

image

 

Points connected by lines to slightly emphasize individual values

image

 

Columns to emphasize and support comparisons between individual values

image

Part-to-Whole

Bars and Columns

image

Deviation

Lines to emphasize the overall shape of the data

image

 

Points connected by lines to slightly emphasize individual data points

image

 

Bars and Columns to emphasize individual values

image

Distribution

Columns to emphasize individual values

image

 

Lines to emphasize the overall shape of he data

image

Correlation

Points and a trend line in the form of a scatter plot

image

 

Armed with this set of rules you would rule out Seth’s pie chart, and use the bar chart in the appropriated business context.

Read More


Excel Dashboard           OR           Access Dashboard


Posted under Uncategorized |

Sorry, comments for this entry are closed at this time.