Forum Discussion
Stacked Column Chart - One colour per stack
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.
3 Replies
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.
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.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.
