5 Replies Latest reply on Nov 26, 2013 11:33 AM by Justin Smith

# stacked bars

Hi,

I have a stacked bar. I want to unstack the bar. Attached the workbook

i want to see sales and profit in a unstacked bar one over the other. If i am not clear please let me know.

• ###### 1. Re: stacked bars

Like this? You said unstacked bar one over the other, so I'm assuming you want a stacked bar where you can actually see what part of sales is profit. The attached does. What I did was change the mark color for profit, then move its pill on the rows shelf to the right. Finally, synchronize the right axis.

If I'm confused, let me know and I'll try again.

Justin

• ###### 2. Re: stacked bars

justin,

This is what i am looking for. I tried to do the same way you did but "no luck".

• ###### 3. Re: Re: stacked bars

Tableau Stacked Bar to Show Profit as a Part of Sales - YouTube

Sorry for the choppy video - first time using hangouts on air.

• ###### 4. Re: Re: stacked bars

Hi Justin,

This has been very useful. I have a related question -

I am trying to do a stacked bar chart as well, but I would like it to be additive.

I have two measures:

1. Sum of Sales
2. Calculated Field to show Increase in Sales

Currently, both measures are starting at the origin of the synchronized axis. I'd like it to display Sum of Sales in one color and then the Increase in Sales stacked on top of that, to show the potential gain based on the parameter setting.

Thoughts?

Thanks!

• ###### 5. Re: Re: stacked bars

Kevin - I'm assuming since you mentioned a parameter you are trying to show the increase in sales based on a user's input into that parameter probably as a percentage. Are these assumptions accurate? Second, is the projection ALWAYS an Increase, or do you need to be able to show the stacked bar if the user enters a decrease? I have a solution for both, but the option for a decrease makes it a little more involved. Not hard, just a few more steps.

Justin