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 ...
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)
