Colormix 2 color range when data is mostly on one side of a 1-100 spectrum

Shouq — Mon, 21 Oct 2024 08:06:16 GMT

Hello,

I have a table and one of the columns has percentages ranging from 9 - 23 percent.

I want my colour range (green to yellow to red) to be fully represented. Unfortunately, because the data is so close together and off centre, I keep getting different levels of mostly the same colour.

I have tried different combinations but I'm not entirely sure how to fix this.

This is my current best formula, it gives me a good range of yellow and green but completely ignores the red.

ColorMix2(rank(total column(3))/noofrows(TOTAL),red(), yellow(), Green())

Re: Colormix 2 color range when data is mostly on one side of a 1-100 spectrum

Shouq — Mon, 21 Oct 2024 08:07:06 GMT

topic Colormix 2 color range when data is mostly on one side of a 1-100 spectrum in App Development

Colormix 2 color range when data is mostly on one side of a 1-100 spectrum

Re: Colormix 2 color range when data is mostly on one side of a 1-100 spectrum