Dynamically Update Chart Labels.

[Dokat]

Hi,

I want my chart labels to automatically update. I am using below formula but it only works if the value is above 1000. How can i add a third condition when the value is less than 1000, it shows the actual value

[>499999] #,,"M";#,"K"

Thanks

 

[Hui]

[>499999] #,,"M";[>999]#,"K";#

 

[Dokat]

[>499999] #,,"M";[>999]#,"K";#

it works, thank you