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

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


"gigi" <(E-Mail Removed)> wrote in message
news:577601c42d2f$df729dc0$(E-Mail Removed)...
> 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

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
>
>
>"gigi" <(E-Mail Removed)> wrote in
message
>news:577601c42d2f$df729dc0$(E-Mail Removed)...
>> 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
>
>
>.
>

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...%40tkmsftngp04
http://groups.google.com/groups?selm...%40tkmsftngp04

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

gigi wrote:

> 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
>>
>>
>>"gigi" <(E-Mail Removed)> wrote in
>
> message
>
>>news:577601c42d2f$df729dc0$(E-Mail Removed)...
>>
>>>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
>>
>>
>>.
>>