Data Viz Done Right

January 17, 2017

Tableau Tip Tuesday: How to Create Waffle Charts

9 comments

I love waffles! So why not learn how to make waffle charts? This week, I show you a very simple way to create them. Inspiration for this post came from this post by Russell Christopher. The difference between his post and mine is that I don’t require any table calculations; that’s nearly always a win for me!

I created a template for the grid layout (the primary data source that I use in the video), which you can find here. I’d love to see more examples that you build with this. Good luck!

9 comments :

  1. Very Nice! I love this approach. You could potentially cross join another Excel sheet with Regions to get a data source that allowed you to create all charts in a single view (and blend on Region). Thanks for sharing!

    ReplyDelete
    Replies
    1. Ah, good thinking there Joshua! Thanks!

      Delete
    2. Hi Joshua.How should I go with your approach? I am new to Tableau...So trying this challenge....How to cross join? How should the data look in that excel?

      Delete
  2. Andy, thank you for this video. This was a great and easy to follow tutorial.

    One difference I can see in my end product is that there seems to be two thicker lines in my chart and I cannot figure out where they are coming from. Anything that immediately comes to mind? I thought it might have been the border on the annotation, but that was not it.

    https://public.tableau.com/views/WaffleChart_2/WhichRegionsHavetheHighestProfitRatio?:embed=y&:display_count=yes

    ReplyDelete
    Replies
    1. Now, that I am looking at the published version, it seems to be every other row is a thicker line.

      Delete
  3. This is super useful. Thanks, Andy!

    ReplyDelete
  4. I have successfully created the waffle chart. But I can't get it to filter with the rest of my dashboard. I think this is due to the data blend aspect of the sheet. Any idea of how to fix this?

    ReplyDelete
  5. Hi Andy! Great Tutorial! What if in the "Box to Color" field, the ratio is not calculated but already given in the data set? In this case the ratio has to be aggregated in the "Box to Color" and wouldn't show the true/false color. Thanks!

    ReplyDelete