Hi,
We are having APEX23.2
I have 2 charts showing data from same table with the same query, except for different metric value column

But, if we look at the LEGEND items, they show different colours and are sorted differently.
The top chart shows legend items sorted correctly. But, the second one is wrongly sorted.
Correct order <100K, 100-250K, 250-500K, 500-1M, > 1M
How can I get the sorting same as first one?
And also why are the colours different for the same series/labels?
Please suggest.
Thanks