calculating radix for logaritmical scale?

donalde

Board Regular
Joined
Feb 27, 2002
Messages
80
I was wondering, if there is method for calculating radix for logarhitmical scale.

I have values like this:
A B
809,4 2741,92
1567,68 5483,85
2351,52 8225,78
3435,36 10967,71
4703,04 16451,56

C D
502 3889,31
755 4486,45
1156 6670,07
1435 9108,07
2129 12928,26
2809 17802,73

I want to have chart where B and D are displayed (Y-axis) and values of A and C specify X-axis. So, is there way to calculate redix for logaritmical scale in x-axis? I could try by just testing values for redix, but since cases like this appear quite often in my work, I want to know if there is any good method for calculating, not guessing.

- donalde -
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Check out the online help for the LOGEST function}: it tries to fit data to the
form y = b * m^x
I think that m would be your radix.

LOGEST is an array function, so you will
need to use Ctrl-Shift-Enter instead
of Enter when you use it.

Good luck!
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,184
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