Forum Discussion
Number in scientific notation on the axis
Hello!
I am getting a bit crazy because I haven't found a reply yet, and maybe there is no solution.
Anyway, my question is: I have some data with very small values and I don't mind seeing them in a scientific notation (like 2.84E-07), but when it comes to creating a graph I need to write on the axis the value like 2 x 10^-7 (even better if "-7" is written as a superscript), without any E.
Is there a solution?
Thank you very much,
Ilaria
5 Replies
Would 'faking' the chart work for you?
In reality the y-axis values have been multiplied by 10^9 and it is only a number format
0 "x 10¯⁹"that makes the number display with the factor of 10.
Thank you very much for your reply PeterBartholomew1!
Unfortunately I have just tried but it doesn't work to me.
This is the file I used to generate the image. Firstly, does the workbook function correctly and, if so, is the idea usable? With very large numbers the idea would work better because formats like
#,##0.00,,_ ;-#,##0.00,,display the result in millions whilst retaining the value of the underlying number (no faking it)
Afraid not. You may convert your numbers into the texts in desired form, but that will break the chart.
SergeiBaklan thank you very much for your kind reply, even if I hoped to have a hope 😞
