Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formating with TEXT | Excel Discussion (Misc queries) | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Vlookup did cell auto formating but not displaying complete text.. | Excel Worksheet Functions |