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:

https://public.tableau.com/views/PublicSafetyDrones/Dashboard?:display_count=y&:origin=viz_share_link