Building advanced charts in Tableau

Overview

Time: min
Objectives
  • How to develop advanced charts in tableau

You will get a chart like this.

Screen Shot 2022-03-21 at 6 40 08 PM

Next, select bar chart from the marks card sum of sales.

Screen Shot 2022-03-21 at 6 40 33 PM

Adjust the size of the bar as follows.

Screen Shot 2022-03-21 at 6 41 01 PM

Screen Shot 2022-03-21 at 6 41 15 PM

Similarly, you can adjust the size of the bubble. To add labels to the visualization, click on marks card and select show marks label.

Screen Shot 2022-03-21 at 6 41 40 PM

To categorize it according to the category, add category from the dimensions to colors marks cardfor the sum of sales.

Screen Shot 2022-03-21 at 6 42 07 PM

Screen Shot 2022-03-21 at 6 42 52 PM

Screen Shot 2022-03-21 at 6 43 09 PM

Add category to colors marks card.

Screen Shot 2022-03-21 at 6 43 40 PM

Screen Shot 2022-03-21 at 6 44 16 PM

Screen Shot 2022-03-21 at 6 44 33 PM

To create a donut chart,we now need to duplicate thepie chart. To do so double click on column shelf and type in 1. This will create a fake axis. Change the aggregation to minimum. And create a duplicate of the fake axis by pressing control and dragging the axis in column shelf again.

Screen Shot 2022-03-21 at 6 45 06 PM

Increase the size of the pie chart through the size marks card. Remove ship mode from the color in the second min(1) marks card.

Screen Shot 2022-03-21 at 6 45 35 PM

Decrease the size of the pie and change the axis to dual axis in the column shelf.

Screen Shot 2022-03-21 at 6 46 11 PM

Next step is to synchronize both the axis and remove the header(uncheck the show header option).

Screen Shot 2022-03-21 at 6 46 37 PM

Change the color of the center part as whiteand add sales to the label marks card.

Screen Shot 2022-03-21 at 6 47 04 PM

Now if we add region to the column shelf, we will have multiple donut chart.

Screen Shot 2022-03-21 at 6 47 32 PM

Screen Shot 2022-03-21 at 6 48 02 PM

Add sub-category to columnshelf, profits to row shelfand negative profits (calculated field) to the size marks card.

Screen Shot 2022-03-21 at 6 48 29 PM

From sum of profits in the rows column select running total from the quick table calculations.

Screen Shot 2022-03-21 at 6 49 00 PM

Select Gantt Bar from the marks card.

Screen Shot 2022-03-21 at 7 35 34 PM

Screen Shot 2022-03-21 at 7 36 48 PM

Click on edit axis on the first chart and select scale as reverse.

Screen Shot 2022-03-21 at 7 37 26 PM

Screen Shot 2022-03-21 at 7 37 46 PM

This gives us a funnel chart.

Key Points