Making Every “Show Me” Chart From Scratch: Part Two

Ah… The much-awaited Part Two of my ‘Making Every “Show Me” Chart From Scratch” series (see part one here). Thank you for following my series so far! To recap, we have so far gone through text tables, heat maps, highlight tables, symbol maps, filled maps and pie charts.

In this post, I will go through how to create a bar chart, stacked bar chart, side-by-side bar chart, treemap, circle view and side-by-side circles. For this series, I will be using the “EU Superstore” dataset found in My Tableau Repository.

Let’s get started!


Horizontal Bar Chart

Tableau’s Show Me bar chart is known as “Horizontal Bars”, though really, bar charts can be both vertical and horizontal. I will show you both. For this bar chart, I want to look at the profit for each sub-category.

Step One

Drag the measure “Profit” to the Columns Shelf and the dimension “Category” to the Rows Shelf. As we want to look at sub-category, we can either drag the dimension “Sub-Category” to the Rows Shelf next to “Category” or the quicker way: click the little plus sign shown in Figure 1. This expands category to its next level of detail, sub-category. This only works because sub-category is below category in its hierarchy. If these dimensions aren’t in a hierarchy together, the regular drag-and-drop works too.

Figure 1. Building a horizontal bar chart

Click to Keep Reading!