I have 2 questions:
- I have 2 Status columns that I want to represent on the same chart, but I can’t find a way of doing this. Each item/row has a 2 RAG status (Red/Amber/Green) columns and I want the number of Red, Amber and Green items from both columns, is it possible?
- I want to change the order in which the bars are represented on the chart, Green, then Amber, then Red, but is seems to put them in alphabetical order. I want them in the order that they appear in the drop down list of statuses in the table. Can this be done?