Hi All,
I have an issue for setting colours in my chart (first picture below). This chart contains 3 criteria in the legend: Minor, Intermediate and Major. I have set up in the 'Format Chart Data' window (second picture below) to have Major in red, Intermediate in orange and Minor in Green.
But when I get only the criteria Minor, the colour for Minor will be red instead of green because the Format Chart Data is set up by order of appearance.
My question: can we set up the legend colour by criteria instead of the appearance order?
Thank you very much for your help