Set Chart FormatAxis Decimal Places according to value in a cell

[mrprofit]

how do I set the decimal places of the Format Axis by a value in Cell P1, "0.000"


something like this?

Please Login or Register  to view this content.

[LJMetzger]

Hi mrprofit,

On Excel 2003 the syntax (tested and working) is:

Please Login or Register  to view this content.

You probably need 'Text' instead of 'Value':

Please Login or Register  to view this content.

I prefer on one line like you have it, but I used 'With' for PrettyPrint purposes.

Lewis