I have a bar chart where there are between 5 and 7 values in the stacks depending on which chart selection you make
For example on Ageing, have a 120Days, 150 Days and 180Days Ageing.
120Days for example will have Current, 30, 60, 90 and then 120+ Days
I need the colours to stand out from each other so the user can clearly differentiate between the values. The Current will always be Green where the 120, or 150 or 180 depending on the selection will always be red.
Is there a way automatically of doing this or would I need to hard code each chart