I'm looking for an automatic way to format the value axis with the least
number of digits possible after the decimal. I want the format to switch
from #,##0 to #,##0.0 to #,##0.00, etc. as needed.

That is, I never want the Y axis to display the same number twice, because
that means we need to add more digits to the right of the decimal. And I
never want the Y axis to display "0" in every right-most character after the
decimal, because that means we need to reduce the number of digits
displayed.

Other than using macros, can anyone suggest a way to display the least
number of digits after the decimal?

Thanks.

Charley