MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Logarithmic Axis


Posted by Melody on October 08, 2001 5:59 AM

I am working on a chart, which needs to have logarithmic axis (both X & Y). I've got that set up, but the problem is that Excel defaults to showing only 1, 100, 1000, etc. I need to show gridlines for 1 thru 10, 20, 30, 40, etc. to 100, then each 100 point, etc. How do I get Excel to do this for me?


Posted by Mark O'Brien on October 08, 2001 6:36 AM

Select the chart, then go to Chart|Chart Options. Click on the gridlines tab, you should be able to select minor gridlines for the x and y axes.

Posted by Melody on October 08, 2001 7:34 AM

OK -- that worked for showing the gridlines. One more question, though -- how do I get the chart to only show thru, say 300? Right now it cuts off at the next major logorithmic value (1000), but the chart I'm going off of cuts at 300.

Thanks again!

Posted by Mark O'Brien on October 08, 2001 9:17 AM

As far as I can tell, you can't change the axis in this way. I think you may have to live with it.

Of course, I could easily be wrong.