Log-scale histograms

Originally Posted by shg

Right-click the axis, Format Axis, tick Logarithmic Scale

Thanks. Unfortunately, I can do right click and 'Format Axis...' but then there is no obvious option for a logarithmic scale.

excel histogram format axis.PNG

I've hunted through all the tabs in that dialog box, but couldn't find anything suitable. Where is the option for logarithmic scale?

EDIT: The MS help page for changing axis scales doesn't mention logarithms either.
http://office.microsoft.com/en-us/wo...010342254.aspx

EDIT2: It seems that I can set a log scale on the vertical axis.

excel vertical axis log scale.PNG

Any idea how to get this option for the horizontal axis too?