How to change the scale of the Gauge

[Anonymous]

Hi,

wondering, could I change the Max of the Gauge to the Max(Sales)

here is the graph

Have the BestDailyperformace is The Max(Sales)

Have the Gauge is Avg(Sales)

want to change the final end of the Gauge into the dynamic one = Max(Sales) above.

Is that possible and how could I do that?

Regards,

[simon_minifie · Accepted solution]

Hi Celine,

The gauge range can be amended in Appearance -> Presentation of the object.

The min and max limits can be set via an expression.

Thanks,

Simon

[shraddha_g]

In Range Limits ,

In Max  - > put Max(Sales)

[Anonymous]

Thank you!

[Anonymous]

Hi Simon, thank you!

Sorry do you also happen to know could change the size and position of the Gauge title? which aligns with the one 'BestpDailyPerformace' above?

Thank you!

[simon_minifie]

Hi Celine,

Actually, no.. I tried

=Repeat(chr(32), 10)&'Title'

Which should insert 10 spaces before the title, but it seems to ignore any formatting before the text.

There doesn't seem to be any other centering option unless someone else has an idea?

Sorry.

Thanks,

Simon

[Anonymous]

Thank you for the info.  You have helped me a lot!

Regards,

Celine