Log axes

On a log scale, Excel will not let me put maximum or
minimum chart axis values other than 0.01, 0.1, 1, 10 etc..
My data range is small: 0.950-1.050 making any work with a
log-scale between 0.1 to 10 a pig to see.

Any solutions?

Cheers

Joe

JoeD wrote:
On a log scale, Excel will not let me put maximum or
minimum chart axis values other than 0.01, 0.1, 1, 10 etc..
My data range is small: 0.950-1.050 making any work with a
log-scale between 0.1 to 10 a pig to see.

Any solutions?

Cheers

Joe

With such a small range, there is not much difference between log and linear
scales. There is a solution, although it's a little more complex than
setting the appropriate checkboxes . Try the following link:
www.tushar-mehta.com, Flexible Log Scale on the left side

Dave
dvt at psu dot edu

Joe -

Tushar Mehta has a tutorial showing how to customize your log axis scale
parameters, at http://tushar-mehta.com.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

JoeD wrote:
On a log scale, Excel will not let me put maximum or
minimum chart axis values other than 0.01, 0.1, 1, 10 etc..
My data range is small: 0.950-1.050 making any work with a
log-scale between 0.1 to 10 a pig to see.

Any solutions?

Cheers

Joe