jalvarez
Chemical
- Mar 12, 2004
- 93
Refining Excel results... ![[pipe]](/data/assets/smilies/pipe.gif "[pipe] [pipe]")
Hi, colleagues
Sometimes, making a plot in Excel, we may prefer a logarithmic graphic. This is an option using the Excel wizard for a graphic.
But trying to define the maximum value for the "y" variable, Excel increases such muber to the log decade immediatly up.
I mean, if you put 5000 as the maximum for the "y" axis, Excel will show 10000 as the maximum.
This is different if a linear scale is selected, Excel will show in the graph any number you establish as the maximum.
Does anybody know if there is a trick to obtain what I described, id est, a graph showing 5000 (or any number different to 1; 10; 100; 1000; 10000, etc.)?
Have a safe day
Jorge Alvarez
Hi, colleagues
Sometimes, making a plot in Excel, we may prefer a logarithmic graphic. This is an option using the Excel wizard for a graphic.
But trying to define the maximum value for the "y" variable, Excel increases such muber to the log decade immediatly up.
I mean, if you put 5000 as the maximum for the "y" axis, Excel will show 10000 as the maximum.
This is different if a linear scale is selected, Excel will show in the graph any number you establish as the maximum.
Does anybody know if there is a trick to obtain what I described, id est, a graph showing 5000 (or any number different to 1; 10; 100; 1000; 10000, etc.)?
Have a safe day
Jorge Alvarez
