Chart Makeovers

Earlier, Zach wrote a blog post on the ins and outs of chart selection. It reminded us how important it is to balance the right chart with the right visual presentation as dimensions and complexity change.

But your data presentation decisions don't end there! Once you have a good handle on the right structure for organizing the presentation, you have to make it look good - making it function good and accomplish original goals. As promised in the previous post, here are the chosen chart structures at each stage of complexity redesigned for presentation. We'll keep this simple with before and after shots, key design principles highlighted, and a freeform reflection on some practical design decisions. The explanations aren't meant to be exhaustive but rather are a glimpse into design thinking.

Phase 1 | Sales + Calls, Aggregate Performance

Before & After Phase 1,  Phase 1 | Before and After

Design Principles

  • Visualisation is not always the best solution
  • Emphasise the interesting

Design Reflection

  • For fonts, often the best choice is sans-serif, tabular fonts (like this). For this demonstration I simply used Helvetica because it gets the job done and everyone has access to it. The font size is 18pt for primary values and 12pt for secondary.
  • Qualitative values (calls, sales) will often be the text that should be treated with grey (50% black will do for most situations).
  • Quantitive values (559, 71,739) should be clear and easily distinguished from less immediately critcal information. Here they are bold, 80% black.
  • Superscript the dollar sign since its an unchanging qualitiative value.

Phase 2 | Sales + Calls / Product, Aggregate Performance

Before & After Phase 2, Phase 2 | Before and After

Design Principles

  • Use color carefully
  • Use 50% grey carefully
  • Visual rhythm
  • Consider text style needs for dynamic content
  • Organize data visuals in a way that mimics thought process comparisons where appropriate

Design Reflection

  • Stacking the calls and sales bars should only be done with the right audience in mind. Though a dollar to calls value is not comparable in and of itself, in the midst of the context of other products, this makes it easier to visually compare the proportions of these values against each other from product to product. For example, immediately one can notice 'Ceramic Smoking Baby' is a lucrative product.
  • Add consistent, distinct visual rhythm with light separation lines
  • Again, color should only be used to distinguish commonly changing quantitative values: numbers and bars in this case. But sometimes carefully using color on qualitative values can be helpful. The title (’Calls’), value (’202’), and visual representation (longest bar in this case) is an example good color management. No legend is needed, because the content itself explains visual relationships. The content is the legend.
  • Choose your 50% grey visuals wisely. Product names are secondary in visual weight to colored data values, because they are secondary mentally in the thought process of reading this chart.
  • Placing metric values to the left of the bars overcomes problematic rendering issues when values are very small.
  • Dollar signs are not superscripted because they would become unreadable.

Phase 3 | Sales + Calls / Time, Aggregate Performance

Before & After Phase 3, Phase 3 | Before and After

Design Principles

  • Minimize chart junk
  • Use white space for comfortable reading
  • Remove text values that can easily be interpreted with visual counterparts

Design Reflection

  • Center trend values on vertical hash marks
  • Measurement dimensions should be grey
  • Distinguish current date with value and endpoint
  • Remove extraneous date values that can be easily interpreted with well placed light hash marks
  • Distinguish every 5 hash marks with length difference

Phase 4 | Sales + Calls / Product + Time, Aggregate Performance

Before & After Phase 4, Phase 4 | Before and After

Design Principles

  • Give values context
  • Red is easily noticeable when used sparingly
  • Allow for easy comparison

Design Reflection

  • I put the sparklines first in the visual reading for two reasons: 1) the width of this graphic is always the same/dependable and 2) the context of data is often helpful to present first so subsequent values can be better understood. This little snapshot of time provides that context.
  • On the sparklines, distinguish today's value and the lowest value (red dot). Use red carefully. You don't need much to draw attention (where color blind issues aren't an issue)
  • Be sure to provide ample space between elements, and that all graphical elements are aligned on your grid.
This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License. All source code is released under a BSD License unless otherwise specified.

7 comments | Show all comments only the last 5 are shown


May 25, 2010
James Lytle said:

Thanks Josh, glad you found it helpful.

mc2, good observation. As with most final designs, I created all the 'after' images from scratch in Adobe Illustrator to allow full control. But even little things like using 80% grey instead of full black often render a cleaner feel at smaller font sizes.


June 2, 2010
mc2 said:

Thanks James, really good article btw. :)


June 9, 2010
Daniel said:

Thanks a lot!!! Very helpful article!


June 28, 2010
AdamV said:

Some thoughts:
In phase2, I disagree that alternating bars help. The two separate charts show the patterns across categories more effectively. If you want to show comparison of calls/sales, chart the ratio explicitly. I agree with moving the labels (values) out of the bars, which has the added benefit of enabling them to be right-aligned.
Phase3 - using a dashed line for one of the gridlines draws attention to it and makes me wonder if it has a specific meaning, such as a target or an average line. If you want it to be less prominent, a thinner line or lighter shade would be better and less "attention seeking". Losing the data points is great, I am not convinced even the last one is needed, the intent of the label is clear enough. If you feel it is needed, make it smaller.
Phase4 - continuing from my version of phase2, I would keep the sparkline for each chart next to the related number and bar as you have done, but with separate areas for calls and sales, rather than alternating lines (more like your before layout but with sparklines, values, bars in that order as per your after).

This makes comparisons of the patterns for calls and for sales between categories clearer. The benefit of comparing low/high periods for calls and sales may have some value however (maybe highlighting a lag between them), so possibly keep the second sparkline in each case but in a much more subdued shade. (so calls has sales as light line, sales has calls as a light line). Again, lose the dot for the final data point and that means your red dot does not need to be red (or at least you don't have to worry about colour blindness). I would prefer to highlight high points rather than last points, almost every time.

Great ideas and promotion of better practices, keep it up!


July 23, 2010
Koen said:

How did you manage to superscript the $ sign? Is there any way to do this in custom formats or would you convert the cell into text? Thanks! Great article.

Your name

Email (optional, will not be shared)

Type the word "juice" (required to confuse the spammers)

Your comment


Add a comment