Pimp My Viz: Toyota Edition


Pimp My Viz: Toyota Edition

I took a holiday break from pimping and vizzing for the InterWorks blog, but we’re back with our second installment of Pimp My Viz. This time, I went to the internet to find public information, landing on a portion of Toyota’s annual reporting.

Sales and Production Version 1

Here is the original spreadsheet from the Toyota website:

This is your basic Excel spreadsheet. A similar sheet was used to get their production information by country / region.

Sales and Production Version 2

Obviously, this is begging for a viz makeover. Right off the bat, you’re probably looking at the neon yellow columns. It’s practically paralyzing to actually get to any analysis, which should start with the July Cumulative Total column. About a third of this chart is using a single, very strong alarm color and it obfuscates the intent of this view. Plus, I wanted to put some extra polish on these numbers so that this dashboard would complement the visual elements of the more dynamic pages, while also leveraging familiar visualizations. I used this image from Toyota’s annual report as inspiration:

I started by revisiting the chart type within the original crosstab. Crosstabs have a specific function in the tool chest of chart types. It’s best when they’re used as an index for look-up values. Sure, users of this report might want to see the specific sales figure for South Africa in 2013, but in my opinion, there’s more value in highlighting the trend of sales over several years (i.e. line graph). I’m also interested in showing the distribution of Toyota’s global business as a part to the whole. Since Toyota was already using donut charts in their view above, we’ll stick with those. Combining these more useful chart types with this data, along with a more conservative use of color and some interactivity, we can consolidate this wall of numbers into a far more focused report.

Here’s what I came up with:

One of my stylistic tells is using the relatively new feature of transparent backgrounds, which I’ve done here with a global map PNG with the pin map overlaid on top of it. I couldn’t use a Tableau map as I didn’t want the countries to be marks and thus selectable.

Interested in Pimping Your Viz, Too?

If you have some visualizations that you would like to expose to an extreme makeover, please let me know in the comments below. I’m aiming to do one of these each month. The only requirement is that your workbook is publicly available (i.e. data is not sensitive) so that I can share the before and after on the InterWorks blog and Tableau Public.

And for all your Tableau or data needs, remember InterWorks is ready to help!

More About the Author

Robert Curtis

ANZ Market Lead
Pimp My Viz: Toyota Edition I took a holiday break from pimping and vizzing for the InterWorks blog, but we’re back with our second installment of Pimp My Viz. ...
New Year’s Resolution: Tableau Tips to Go from Junior to Jedi One of the questions that I’ve been getting a lot lately when I present on analytics is: how do you get good at Tableau? I’m going to ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK


Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072