In a previous article, we showed how to create waffle chart from a single percentage, without extra data table and without table join. Also the labeling is automated instead of manual, comparing to other approaches.

Now we are going to apply the same method to creating waffle chart for multiple percentages as follows. Note that the percentages are calculated horizontally, showing the percentages in different regions per each category.

The steps are: (The 2nd step uses a different approach from the previous one for the same result.)

1.Union the data source with itself.

This will generate a new column Table Name with two different table names.

2.Use the two table names to define the first and 100th points

For each waffle chart, we need to have a 10x10 grid of 100 data points.

Waffle chart is popular for visualizing a single percentage. How can we create such a chart?

Here are the steps. The example data source has a single data record.

1.Union the data source with itself.

Thus the data source has two records now. And it generates a new column: Table Name

2.Define the first and 100th points

Based on the two table names, we can define the two points. We need to have 100 points to create a waffle chart, as a 10x10 grid.

Usually when we create a bar chart with 2 hierarchical dimensions such as Category and Sub-Category, we will have bars at the Sub-Category level and roll-ups at the Category level. Here is a chart we can create easily.

This is simple but it doesn't show the hierarchical relationship very well.

Today, we have an alternative way to chart the the bars and their hierarchical relationship as follows:

The grey bars for Category is created using reference lines.
Blog Archive
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.