Stacked Column Chart - One colour per stack

[DrewSmith]

Hi, 

I've a client that's looking to have a stacked column chart that uses a RAG status. The below works, but they are looking for the stack of Red/Amber/Green to be those colours, yet split out by the project. 

To me, this visual isn't suitable for what they are after, however, how can I change the below so all Amber is Amber and all Green is Green. To me, something like a sunburst or simple column chart would be better. I know how to change the colour for items on the Y Axis but that changes both amber and green and cannot see an option to do this for one column only. 

[audreygerred]

Hello! Right now, is RAG the x-axis and the project is the legend? Instead, can you swap so that RAG is teh legend and Project is the x-axis? This way each project will be listed along the axis and you will be able to see how many RAG each has.

[DrewSmith]

I've created a table to bring the column from the seven other tables into one, but that still hasn't work. 

Works well as a Sunburst, and can work as stacked column with one colour for all. 

[DrewSmith]

Hi, 
It won't let me swap the RAG in X Axis to Legend, but I see what you were trying to do. 
The projects come from 7 different tables so at the moment Y Axis is RAG and X axis is the count of the rows in the seven tables.