Comparing Two or Three Categories in Tableau

by Sijia Wei

I quite like this chart type we did with Andy, he calls it ‘Peas in a Pod’. I like the way it looks, and it works very effectively when comparing between categories, eg. Gender, Party, etc.

Step1: Put Dimensions and Measures on Columns and Rows, Category on Colour

Step2: Copy SUM(Sales) in the Columns, make it a Line Chart

Step3: Move Category on Path

Step4: Dual Axis

A bit formatting and it’s done!

This is how I’ve used it in Dashboard Week Day 1:

© 2022 The Information Lab Ltd. All rights reserved.