How to make bar or column chart colors dynamic when changing dates?
I have this chart where I have several categories on x-axis so I'm finding a way around for the least cost to be blue and the highest cost as red whenever it changes dates and the rest say gray