DSA Insights

Here are two charts that débuted in the June 9th issue of BusinessWeek and reminded me of a recent newsletter from Stephen Few found here.  I have noticed that they [BusinessWeek} tend to use colors that jump out at you for that WOW factor.  I may not have picked this color, but when you see all of the graphics with the same color scheme on one page, it definitely works.

Here is the Excel color palette, which contains the lime green color.   In the chart on top, the graphic designer used the top color (black) and the middle color (lime green) found below to differentiate between 2004 and 2008.  In the map image, just lime green was used to highlight some states regarding the average cost per day for a private room in a nursing home.

As I learned from Stephen Few's newsletter, an excellent expert resource regarding color [besides Stephen's article} is Cindy Brewer's website found here.

Here are a few examples regarding the use of color in a column chart.  In my opinion, the first example below is one of the biggest abuses of color in chart design.

Novice:

Often, I see colors used in charts with the sole purpose to be colorful.  A perfect example would be the rainbow column chart (below), where a different color is used for each column.

Better:

A better option for the column chart would be to use more effective colors that are all the same.

Expert:

An expert may use the same color except for the column that they are pointing out.  By using this technique, the reader's attention is immediately drawn to the value for June (black).

 

Best:

A line graph would be a better option for showing the Widget sales over time.  Whenever time is on the x-axis, a line graph is probably a better option unless you're trying to illustrate a certain point.  If you want to highlight a certain time period, the use of text boxes [with high transparency] can be handy.

 

Support Analytics Consulting

DSA Insights Home

This entry was posted on Monday, June 9th, 2008 at 2:23 am and is filed under Analytics, BI, Excel, Reporting, Tony. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.