Axis values with 10 to the power of -2,-1,0,1,2,3,4,5


I am creating diagrams with a logarithmic x-axis. Now the x-axis shows 0.01, 0.1, 1, 10, 100, 1000… But instead I would like to have this kind of notation:

Thanks in advance

You cannot get exponents, but you can use a scientific notation of kind 1E+1 or 1E-12. Go to tab “Numbers” in the formatting dialog of the axis. Uncheck “Source format” and use 0E+# as Format code.

Pity it doesn’t work…
I’ll try to submit an enhancement bug. In my opinion this would be a neat feature!

Obviously the formats of the numbers axes can be labeled with are exactly those also usable in Cells. Even any calculated text cannot consist of differently formatted portions. This includes the creation of true subscripts and superscripts (not just using the few special sub/super characters) . May I suggest you do some research about possible implementations in advance of posting the enhancement request?