Gauge Chart - Set Flexible Max Value

[#1]

Hi, when I create a Gauge Chart, I don't want to hardcode the Max value (Presentation tab).

Example:

if sum(sales) = 105, then Max Value=1000

if sum(sales)= 2090, then Max Value=10,000

Can guide me how to use the expression?

Thanks you

Benjamin See

[MK_QSL · Accepted solution]

Go to Properties of your chart

presentation tab

Guage Settings

Under Max write down below expression

IF(Sum(Sales) = 105, 1000, If(Sum(Sales) = 2090, 10000))

UPDATE:

Another way is to set max at 10% higher

Please check enclosed file.

[#3]

Thanks. Test ok.