Thank you. I think I need a bit more help if you don't mind? If I have budget turnover and want to show variances (Volume, Mix, Price) to arrive at actual turnover how do I best display this as each of the three variances could be positive or negative each in reporting period. (I'm just looking to set up the graph so it auto populates once i have the data). It's not quite pulling through as i expect to see it. Do i need to look the budget turnover and actual turnover down because they are totals and ow do i do it when the column stack is split by multiple products?
amazing - been trying to do this all my life. thank you for the clear explanation!
Glad to hear that - thanks for the feedback!
THANK YOU ! Your made my night ;) !!
Thank you so much! I wanted to make one, and got this! Excellent explanation!! Thank you
Thank you. Very clear.
Yes! Thank you!
You are so welcome!
Thank you, thank you, thank you. You just saved the day!!!
Great stuff! What if I want a total at the top of each bar too?
Thank you. I think I need a bit more help if you don't mind?
If I have budget turnover and want to show variances (Volume, Mix, Price) to arrive at actual turnover how do I best display this as each of the three variances could be positive or negative each in reporting period. (I'm just looking to set up the graph so it auto populates once i have the data). It's not quite pulling through as i expect to see it. Do i need to look the budget turnover and actual turnover down because they are totals and ow do i do it when the column stack is split by multiple products?
*Do I need to lock down
Great
Thanks!
Could you share the excel sheet?