Formatting axis with scientific numbers

[martink]

Hi
I want to format my x axis so that instead of my scale displayin
scientific numbers as 1.00E-07 for example, it is displayed as 10-7.
Any suggestions how this can be done are much appreciated.

Thankyo

 

[Bernard Liengme]

I have never found a way to do this.
I think we should accept 1.2E-4 as a perfectly good alternative to 1.2 x
10^2. After all that how 90% of calculators display small numbers.

 

[Jon Peltier]

See the suggestions in these links. You cannot format the axis labels
themselves, but you can hide them and use datalabels instead, and format
the data labels.

http://groups.google.com/groups?selm=ePgQSao$BHA.1940@tkmsftngp04
http://groups.google.com/groups?selm=eEe64PMCCHA.1272@tkmsftngp04
http://groups.google.com/[email protected]

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______