In this blog I am going to take you step by step to create a waffle chart. I have attached the excel sheets with the data required to create the chart.
A waffle chart is the best way to show percentage values.
Following is what a waffle chart looks like
Step 1 : The first step to create the waffle chart is to get the excel file ready for the waffle . The excel file has the following three columns : Rows , Columns and Percentage . Followng is the format of the excel file :
Step 2: Import the excel file into tableau. Bring Rows and columns from measures to dimentions.
Step 3: Bring the column variable to the column pane and the row variable to the row pane.
Step 4: Add a measure Avg(1) in the columns pane and in the marks select bar. Resize the bars to form the base of the waffle chart.
Step 4 : Sort the rows in descending order.
Step 5: Connect the data file whose percentage is to be shown in the waffle chart (Sample.xlsx in this case).
Step 6: Create a calculated field for the color of the waffle chart
Step 6 : Add the created field to the colors mark . Format the charts and you waffle is ready .