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!

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

Tableau has a super useful “Show Me” function which allows you to choose from 24 chart types based on dimensions and measures you select. This is a brilliant feature for beginners. However, what if you’re a little bit more experienced and want to know how to make these charts from scratch? Or even if you’re a beginner who doesn’t want a shortcut? In this four-part series, I will go through how to create all 24 “Show Me” chart types.

For this series, I will be using the “EU Superstore” dataset found in My Tableau Repository. In this post, I will go through how to create a text table, heat map, highlight table, symbol map, filled map and pie chart.

Let’s get started!

 

Text Table

Text tables are exactly like they sound. A table of values similar to what you get in an Excel spreadsheet. For this text table, I would like to look at how much each sub-category of products have made in sales.

 

Step One

From the Data Pane, drag over the dimension “Sub-Category” over to the Rows Shelf (Figure 1).

Figure 1. Building a text table
Figure 1. Building a text table

Click to Keep Reading!