Mike Cisneros created a viz for the #MakeoverMonday data set on Oil and Gold prices. It is a great design especially in that he devised a correlation metric between the two prices. And he shared his thought process in a well written blog post, which won lots of praises on twitter.

Oil and Gold: Tracking the correlation between the prices of two commodities. #MakeoverMonday #MemoryLaneMonday https://t.co/i5S0nHWbNm pic.twitter.com/3VHowb6AsW

— Miguel Cisneros (@mikevizneros) April 10, 2017 I love the design very much. I think it is even more impactful if we reverse the vertical timeline axis and have the latest year on top. I made a similar tweak in an earlier post.

The advantage is multiple:

- The latest trend or change is always more interesting. It is what we want to emphasize.

[The technique described here applies to tooltips design as well.]

Recently it came to me a question on how to put arrows next to numbers to indicate up/down. Some proposed to use Shapes as data mark in dual axis with numbers. This reminds me a custom number formatting trick that Simon Runc used quite a few times in Tableau forum. This post is to document the trick and all credits go to Simon. Neither shapes nor dual axis are necessary.

This is how it works.
4
Blog Archive
Blog Archive
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.