Excel logarithmic scale?

Question

Hi I need to make a semi-log plot, which is x versus the Natural log of y. From what I've seen, excel only lets you make a logarithmic scale for an axis, when the base is between 2 and 1000. I tried to make it base "e" but it just changes it back to 2 or 10. Does anyone have any idea on changing the scale to a natural log or making the base e.

Answer 1

Base 2.7 works, but I could not get any more significant digits.

Answer 2

Logarithmic Scale Excel

Answer 3

you're able to do an xy-scatter chart, then opt for the axis you opt for to transform to logarithmic scale (X-axis log, Y-axis conventional, then that's semi-log) (X-axis log, Y-axis log, then that's log-log) besides whilst suitable click on any axis, you have "format Axis", then in "Scale" tab, you have a Logarithmic verify field, verify it. savor my profile here, i'm VBAXLMan