8 Replies Latest reply on Mar 3, 2017 3:50 AM by Nikunj Bhardava

# Bar within a Bar Chart

Hi Team - I am trying to build a "Bar within a Bar within a bar " chart . I know how to build 3 bars within a chart but business is asking something that is slightly different. Can anyone help me achieve this , I have attached the screenshot for the reference.

The thin bar ( red/green color) , this color should change based on if it exceeds the grey bar value.

Thank you,

Rashmi

• ###### 1. Re: Bar within a Bar Chart

Rashmi - Can you explain what is the purpose of these three bars? I can try to achieve your desired result.

• ###### 2. Re: Bar within a Bar Chart

The grey bar indicated my previous year spend

blue bar indicates my YTD spend

thin bar is basically indicating overspend or underspend.

Thanks

• ###### 3. Re: Bar within a Bar Chart

Ok. Interesting!! Can you provide some sample data?

• ###### 4. Re: Bar within a Bar Chart

You can connect to any sample data in Tableau and try achieving it with any 3 metrics.

Cheers

• ###### 5. Re: Bar within a Bar Chart

Hi Rasmi - Can you please check attached workbook. I tried to achieve similar to your requirement.

Check by changing Name filter.

Hope this helps!!

Thanks,

Nikunj

3 of 3 people found this helpful
• ###### 6. Re: Bar within a Bar Chart

Hi Nikunj - This is what I was looking for. Can you help me understand the calculations for the "start from 0" and how "calculation1" is looking like a stacked bar?

• ###### 7. Re: Bar within a Bar Chart

Rashmi - I am away from my desk. I don't remember what was "Calculation1", can you post the calculation here so that I can see and give you an answer?

I remember - "Start from 0" - Basically the gray bar you see is a band on axis. so it requires "band start from" and "band ends", so Gray bar that is previous year spend should be start from 0 (Start from 0) and ends to the respective previous year spend value.

Thanks - Nikunj

• ###### 8. Re: Bar within a Bar Chart

Hi - Please check attached workbook for your reference. I have removed stack for gray bar.

Thanks - Nikunj