change scientific format of numbers

[gigi]

Hello,
I'm trying to publish a paper to a scientific journal
including graphs generated with Excel XP. When a log
scale is used the journal format requires the scientific
format of the axis numbers to be like 10^n (10
superscript the exponent number) rather than 1E+n as it
is standard in Excel.
Is there an easy way to change that format?
Thanks,
Gigi

 

[Bernard Liengme]

There is no way to do this with axis number - one of the weakness of Excel
for scientific use.
I expect you could fake it by using labels. How many graphs do you have?

 

[gigi]

I have 7 graphs to be formatted.

-----Original Message-----
There is no way to do this with axis number - one of the weakness of Excel
for scientific use.
I expect you could fake it by using labels. How many graphs do you have?
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address





.

 

[Jon Peltier]

Gigi -

Here are a couple posts I've made that simulate real exponential powers
of ten formatting of the tick labels:

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

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