Formatting axis with scientific numbers

  • Thread starter Thread starter martink
  • Start date Start date
M

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
 
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.
 
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/groups?selm=MPG.15f88f1e472fa9c698a228@msnews.microsoft.com

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