Set Major Units Scale in Gauge Chart using a Macro?

[Anonymous]

Hi,

Is it possible to use a macro to define the Major Units value of a Gauge Chart? If so could you please provide a sample of the code required to achieve this.