Excel log graph with PARTIAL CYCLE

[makolber]

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

 

[smartin]

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" here:
http://www.tushar-mehta.com/excel/newsgroups/flexible_log_scale/

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

 

[Shane Devenshire]

Hi,

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

 

[makolber]

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









- Show quoted text -

thats what I was afraid of..

thanks and thanks to the other replier

Mark