For my Google sheets chart I have set the vertical axis to a logarithmic scale. I would prefer this to be displayed as a powers of 10, is this possible?
What I get:
What I want:
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
It is possible with a fairly extreme hack (that I accept most would not bother with) - the 'usual' overlay what you have with what you want, but a bit more tricky in Google Sheets than I am used to.
First plot the chart (as you have) then adjust the line spacing on a sheet behind the chart so that the rows match the labels for spacing. Chose a font colour for the vertical axis labels to blend into the background -on a (standard) white background select white.
Fill one column with
10s and next to it another with digits for the required powers (largest number at the top). Adjust the vertical alignment of these columns (top for the powers and centre or bottom for the
10s. Adjust the font sizes of each column to suit.
Copy the array into a drawing canvas, save it and move the result where required: