If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Log axes
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 |
#3
|
|||
|
|||
Log axes
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 |
Thread Tools | |
Display Modes | |
|
|