Log axes

  • Thread starter Thread starter JoeD
  • Start date Start date
J

JoeD

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 said:
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
Click to expand...

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
 
Back
Top