I have Actual, Planned and LastYear data for A, B, C, D and their total.
I want a graph in this format.
The bars behind in gray are PlannedTotal and bars over them are ActualTotal. And the line is for LastYear data.
Is it possible to make a graph in the above format but make the ActualTotal into stacked bars for A, B, C and D like this?
I have attached a tableau workbook for reference.
Thanks for your help.
Or here is a sneaky/hacky option using a reference band instead of the planned bar @Lakshya Kumar!
Workbook re-attached.
In addition to what you see in the screenshot, I've turned stacked bars back on and removed measure names off size. Also I've formatted grid lines to give at least some sort of white gap between the reference bands (not the prettiest mind you!).
If you're in a hurry this might buy you some time but I prefer pivoting / reshaping the data!
Ta, Steve.
