Tables in Tableau: Jazzing It Up with a Purpose, Part 3

Data

Tables in Tableau: Jazzing It Up with a Purpose, Part 3

We have now reached the final part of our Tableau Tables Trilogy. For this part, we will be covering what I call the table/chart combo. Why do this? The reason is quite simple. More often than not, people consume data in a table format, spending years consuming tables in Excel, PowerPoint or even Word. So, it is only natural that their go-to data visualisation is a table. This mindset is often so ingrained into the concept of “if I don’t see all the numbers, then I can’t trust the data” that is challenging to convince them otherwise.

However, by introducing small elements such as colour, icons and charts, we can almost re-educate our brain and accept the use of visual aids. Here is where building a table/chart combo can help us start many conversations and change many mindsets, too.

How to Do It Then?

  1. Create a table with the data you wish to display:
  2. Create a bar chart:
    Bar Chart in Tableau
  3. In a dashboard, combine the two elements:
    Table + Bar Chart in Tableau
  4. Maintaining the order of the headers (categories) consistent between the two elements of visualisation (table and bar chart), we can now remove the headers of the bar chart.
    To do this, you can:

    • Right-click on the header and untick the Show Header option from the drop-down menu, OR …
    • On the bar chart worksheet, click on the character Category Drop-down of the Dimension field and untick the Show Header option from the drop-down menu.
      Show Header Drop-down
  5. Adjust the titles and fonts, format colours as preference. You can also add the highlight function across the two sheets so you can simultaneously see the elements of both sheets.

Final Tableau Dashboard

Another option for your visualisation is to use a highlight table and two bar charts like in the following example. Here the highlight table is displaying the sales by region and year, the vertical bar chart showcases the total sales per year and the horizontal bar chart shows the total sales by region:

Tableau Table/Chart Combo

Thank you for reading. If this is the first blog of the trilogy that you are reading, please don’t forget to read Part I and Part II. Happy “Tableauing” everyone!!

More About the Author

Nisa Marques

Analytics Consultant
Tables in Tableau: Jazzing It Up with a Purpose, Part 3 We have now reached the final part of our Tableau Tables Trilogy. For this part, we will be covering what I call the table/chart combo. ...
Tables in Tableau: Jazzing It Up with a Purpose, Part 2 Following the previous blog post, today we will be covering several ways to display negative values in tables. My go-to option is to ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK