I want a x axis log plot with the range of x from say 20 to 200.

I know how to create the log grapgh, no problem there, but Excel seems
to require full cycles..

in other words I can do 10 to 1000,

but not 20 to 1000
and not 10 to 200
and not 20 to 200.

Any ideas?

thanks

Mark

wrote:
I want a x axis log plot with the range of x from say 20 to 200.

I know how to create the log grapgh, no problem there, but Excel seems
to require full cycles..

in other words I can do 10 to 1000,

but not 20 to 1000
and not 10 to 200
and not 20 to 200.

Any ideas?

thanks

Mark

It's all about mocking up the scales and values.

Check out Tushar Mehta's PDF "flexible-log-scale" he
http://www.tushar-mehta.com/excel/ne...ble_log_scale/

Jon Peltier also gives some ideas he
http://peltiertech.com/Excel/Charts/RecipAxisChart.html

Hi,

You are going to have to fake it, because this is the way Excel works.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


" wrote:

I want a x axis log plot with the range of x from say 20 to 200.

I know how to create the log grapgh, no problem there, but Excel seems
to require full cycles..

in other words I can do 10 to 1000,

but not 20 to 1000
and not 10 to 200
and not 20 to 200.

Any ideas?

thanks

Mark

On Feb 10, 8:23*pm, Shane Devenshire
wrote:
Hi,

You are going to have to fake it, because this is the way Excel works.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire



" wrote:
I want a x axis log plot with the range of x from say 20 to 200.

I know how to create the log grapgh, no problem there, but Excel seems
to require full cycles..

in other words I can do 10 to 1000,

*but not 20 to 1000
*and not 10 to 200
*and not 20 to 200.

Any ideas?

thanks

Mark- Hide quoted text -

- Show quoted text -

thats what I was afraid of..

thanks and thanks to the other replier

Mark