View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
smartin smartin is offline
external usenet poster
 
Posts: 915
Default Excel log graph with PARTIAL CYCLE

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