Help on logarithmic scale

[pj_raesh]

hi friends..,

I'm new to Excel development world and I got an assigment from our
company to redesing an excel worksheet with a chart. The 'X' axis
uses logarithmic scale and the value starts from 0.001. They need the
maximum value to end at 200. How can I design this. When I select the
major unit as 10 the 'X' axis values stops at 1000 after 100. Is there
anyway to stop the 'X' axis major unit at 200 while using the
logarithmic scale???

Thanking you,

Rajesh Joy

 

[Tushar Mehta]

hi friends..,

I'm new to Excel development world and I got an assigment from our
company to redesing an excel worksheet with a chart. The 'X' axis
uses logarithmic scale and the value starts from 0.001. They need the
maximum value to end at 200. How can I design this. When I select the
major unit as 10 the 'X' axis values stops at 1000 after 100. Is there
anyway to stop the 'X' axis major unit at 200 while using the
logarithmic scale???

Adapt the following that applies to the y axis:
Flexible Log Scale
http://www.tushar-mehta.com/excel/newsgroups/flexible_log_scale/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions