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.
see
www.stfx.ca/people/bliengme/E...and_Charts.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
quot;Karelquot; gt; wrote in message
news
gt;I make a chart with x-axix values from let's say 1E-9 to 1E-3, using
gt; logaritmic scale. So far so good.
gt;
gt; But my need is not to display the values in the chart like 1E-9, 1E-8,
gt; etc.
gt; but like 10-9, where the -9 text will be formated as upper index.
gt;
gt; Thx for any help or suggestion.
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 (
K.
Bernard Liengme pÃ*Å¡e:
gt; see
gt; www.stfx.ca/people/bliengme/E...and_Charts.htm
gt; best wishes
Here is another option:
www.statit.com/support/top_is...s/gpaynter.htm
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______
quot;Karelquot; gt; wrote in message
news
gt;I make a chart with x-axix values from let's say 1E-9 to 1E-3, using
gt; logaritmic scale. So far so good.
gt;
gt; But my need is not to display the values in the chart like 1E-9, 1E-8,
gt; etc.
gt; but like 10-9, where the -9 text will be formated as upper index.
gt;
gt; Thx for any help or suggestion.
- Jan 12 Mon 2009 20:48
Formating text of x-axix value
close
全站熱搜
留言列表
發表留言