Tableau combination chart

My Use-case

To display a chart with Number of stores across years, differentiating each year by category of the store. In addition, have an overlay that would show the total for the given year based on user selection. This should not modify the underlying chart.

Step 1:

  1. Create a Stacked chart


Rows: Aggregate of number of stores
Columns: Years
Filter: The category of interest (Apparel specialty, supermarket, value market, department store)
Color: Category  
 2. Overlaying chart

2.1. Create a parameter using Year field and select years from 2000 to 2007


2.2. Create a calculated field Highlight Year (IF [Year]=[Parameter 1] THEN 1 END)


2.3. Display the parameter in the sheet and make it a slider, move the Highlight Year to rows shelf1

2.4. Make the Highlight Year row as a dual Axis


2.5. Right click on the right hand side axis and synchronize the Axis


2.6.In the Sum (Highlight Year) marks; remove category from color


2.7. Change the color to white and transparency to 40%


2.8. Change the size to lesser size using the slider


2.9. Add the number of stores to the label



Initial tableau workbook Combination Chart (Right-click and “Save link as…”)

Original creation: 



Print Friendly

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *