Multiple colors in Gauge Chart of a Straight Table

[cristian_av]

Hi

I have a Gauge Chart inside a Straight table. I need to have multiple colors (as the first image above). I've tryied with the following expression without luck:

=Color(RowNo())

=if(RowNo()=2,red(),green()) (Just to try if RowNo works)

This is what I need:

This is what I've have:

Thanks!

[Anil_Babu_Samineni]

Yes, we can. But similar Rounds not possible but work around could possible to show. Can you provide sample

[cristian_av]

I've uploaded a sample!