How to make a y-axis that goes ... -100, -10, -1, 0, 1, 10, 100, ...?

34 Views Asked by At

I want to plot the difference between two variables, i.e. y = A - B. I expect that in some regions of the x-axis one variable will be orders of magnitude higher than the other, and in other regions it'll be the other way round. So in some regions of the x-axis the difference will be massively positive and in others it will be massively negative. Normally when there is such a huge range, a log scale is appropriate... but I don't know if that is possible since negatives are involved. I can visualize what I want (the y-axis would be like: -1000, -100, -10, -1, 0, 1, 10, 100, 1000, etc.) but I don't know how to make this happen in code or in Google Sheets or whatever. Any advice? Is there a name for this sort of thing and I just don't know what it is?