How-to Make an Excel Clustered Stacked Column Chart with Different Colors by Stack

Checkout the Step-by-Step Tutorial here:

If you liked the tutorial I did on Easily creating a stacked clustered column chart,
then you may have wanted to know how to easily create the same chart but instead have different colors for the two different stacked columns (i.e. Budget and Actuals.) Check out how to do it here.

[melchiusmangalam]

Thanks for the information.

I would like to know if the color can be picked based on value in the column cell ?

[TheIlexy]

thanks! is there any possibility to add 2 cumulative lines for Actual and Budget, considering that instead of Product 1 or 2 i have months? I manage to do this by overlapping 2 charts...but maybe there is an easier method.

[nathalyagostofilion]

I was left without a legend when I did the manual color-change, and in this case I think the color variation helps the reader digest the data more easily. Hope you agree!  

Thanks so much!