logarithmic scale

lone

New Member
Joined
Apr 18, 2002
Messages
1
I have a problem which I can't figure out how to solve: I have som data in the range 10 000 to 40 000 and I want to present then in a (x,y)-diagram (I have years from 1980 till 1990 on the x-axis) with logarithmic scale (10-log). But when I choose that, the y-axis will automatically be from 10 000 to 100 000. I would like to have the y-axis from 10 000 to 40 000 and with gridlines between with the numbers 15 000, 20 000, 25 000, 30 000 and 35 000 (which then of course have different length between them). Is this possible? Can I program it in Visual Basic perhaps?
I really would appreciate your help.
Yours Sincerely
Lone Christensen
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
On 2002-04-19 04:32, lone wrote:
I have a problem which I can't figure out how to solve: I have som data in the range 10 000 to 40 000 and I want to present then in a (x,y)-diagram (I have years from 1980 till 1990 on the x-axis) with logarithmic scale (10-log). But when I choose that, the y-axis will automatically be from 10 000 to 100 000. I would like to have the y-axis from 10 000 to 40 000 and with gridlines between with the numbers 15 000, 20 000, 25 000, 30 000 and 35 000 (which then of course have different length between them). Is this possible? Can I program it in Visual Basic perhaps?
I really would appreciate your help.
Yours Sincerely
Lone Christensen

Why are you intent on using a logarithmic scale on the y-axis? What's the nature of these values?
 
Upvote 0
Hi,
You need to format the axis.
Place your cusor over the y axis. Left click
This should open the format axis dialog box.
select the scale tab.
Uncheck the auto box against maximum and minimum and enter the values you want.
You can also select the values for the intervening ticks.

Good Luck
 
Upvote 0
On 2002-04-19 08:22, Lewis wrote:
Hi,
You need to format the axis.
Place your cusor over the y axis. Left click
This should open the format axis dialog box.
select the scale tab.
Uncheck the auto box against maximum and minimum and enter the values you want.
You can also select the values for the intervening ticks.

Good Luck
It seems that minimum and maximum in logarithmic scale are set automatically to n^10 intervals, and there is no way to choose values inbetween.
Eli
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,185
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top