9 Replies Latest reply on Jan 17, 2019 11:15 AM by Mahfooj Khan

Staggered bar chart

Hi Tableau Community,

I was wondering if anyone knew how to create a stacked bar chart with multiple measures. I don't want Tableau to sum up all measures, but values should remain within a range of 0-100%.

Any idea how to do this?

Best,

Imran

• 1. Re: Staggered bar chart

Can you give us a sample data set or packaged workbook as a starting point?

• 2. Re: Staggered bar chart

Here it is

• 3. Re: Staggered bar chart

Why do you want to show both Value and Number of Records?

• 4. Re: Staggered bar chart

want to make staggered bar chat of something similar as attached.

best

Imran

• 5. Re: Staggered bar chart

Hi,

Is that what you wanted?

Create a calculated field to get the % of Total using below logic,

SUM({FIXED [Country],[Vaccine]:SUM([Value])})/

SUM({FIXED [Country]:SUM([Value])})

Let us know if this help. Workbook attached for your reference.

Mahfooj

• 6. Re: Staggered bar chart

Thanks Mahfooj,

No, I want bars differently. Coverage percentages of each vaccine (top of colored bar) should correspond to its actual coverage number (%) along y axis for each country. E.g. Haiti bar for MCV2 till 25%, MCV1 bar goes upto 53%, DPT3 goes upto 60% and DPT1 till 79%.

Its easy to present this data in side bars, but I am trying if it can be done in staggered bar (one bar each country).

• 7. Re: Staggered bar chart

I guess for such data set dot plot chart will be ideal. Grey line represent the threshold (0-100) and dot represents the vaccines and its value (%). Black dotted line is 50% of the value (reference line). You can sort the values in desc order to make it more meaningful and easy to understand.

Take a look

Workbook attached for your reference. Let us know if this work.

Mahfooj

• 8. Re: Staggered bar chart

Thanks a lot Mahfooj.