Formating text of x-axix value
 

I make a chart with x-axix values from let's say 1E-9 to 1E-3, using
logaritmic scale. So far so good.

But my need is not to display the values in the chart like 1E-9, 1E-8, etc.
but like 10-9, where the -9 text will be formated as upper index.

Thx for any help or suggestion.

Formating text of x-axix value
 

see
http://www.stfx.ca/people/bliengme/E...and_Charts.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Karel" wrote in message
...
I make a chart with x-axix values from let's say 1E-9 to 1E-3, using
logaritmic scale. So far so good.

But my need is not to display the values in the chart like 1E-9, 1E-8,
etc.
but like 10-9, where the -9 text will be formated as upper index.

Thx for any help or suggestion.

Formating text of x-axix value
 

Thanks for reply,

does it mean that there is no native Excel solution to this problem?

Your way is suitable when using just localy on my computer or on
instalations where I can distribute the required font. But I need to
subscribe the final charts to journal having its own strict rules about
strange fonts. And unfortunately, this way is accepted :o(

K.

Bernard Liengme pÃ*Å¡e:

see
http://www.stfx.ca/people/bliengme/E...and_Charts.htm
best wishes

Formating text of x-axix value
 

Here is another option:

http://www.statit.com/support/top_is...s/gpaynter.htm

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

"Karel" wrote in message
...
I make a chart with x-axix values from let's say 1E-9 to 1E-3, using
logaritmic scale. So far so good.

But my need is not to display the values in the chart like 1E-9, 1E-8,
etc.
but like 10-9, where the -9 text will be formated as upper index.

Thx for any help or suggestion.