Populate text in gauge chart

[#1]

Hi

Is there a way to populate text beside the gauge chart indicator which will automatically shows ‘Conservative’ (0-25%), ‘Neutral’ (25-50%), ‘Aggressive’ (50-75%), ‘Excessive’ (75-100%)? Following snapshot is an example.

Thanks!

[Nicole-Smith]

Text in chart would be what you'd want.  You can use CTRL+SHIFT to move things around.

[stevedark · Accepted solution]

Hi Heok,

Nicole is on the money with how to place labels in the chart and move them about (Ctrl+Shift is not at all obvious!).  What you will not be able to do is have the text track when the pointer is currently at - you would have to place the text at the appropriate place on the side.

If you wanted only to show the label that describes where the needle is pointing you need to put an expression in the text in chart, it will look a bit like this:

=if( [... your expression ...] <= 0.25, 'Conservative', '')

and

=if( [... your expression ...] > 0.25 and [... your expression ...] <= 0.5, 'Neutral', '')

As you will be repeating your expression a lot I would strongly recommend you move the code for it into a variable.

Hope that helps,

Steve

[#4]

Thanks for your help!

[#5]

Thanks for your help!