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