Get Free Trial

How do i implement 'Color Scales' like excel?

Waller Jhonatan asked on September 14, 2020

Hello flex team,
I’m trying to do an implementation where you have a color scale according to the values of the rows or columns, type a of Excel’s ‘Color Scales’.
I tried to use the heat map, but it compares the value according to a pre-defined minimum and maximum.
Would flexmonster have any support for this implementation?
thank you very much.


color scale.png

2 answers

Mykhailo Halaida Mykhailo Halaida Flexmonster September 15, 2020

Hi Waller,
Thank you for posting your question.
We think you will find the following JSFiddle sample helpful:
Unlike in the other heat map sample you might be referring to, in this one the max & min values are fully dependent on the value in the grid.
More specifically, when the data is loaded to the pivot table, the getData() API call is used to set max & min values which are then used by the customizeCell() function to apply the corresponding formatting.
Please let us know if this helps.
Best regards,

Waller Jhonatan September 15, 2020

thank you very much.

Please login or Register to Submit Answer