Help on logarithmic scale

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

In article <[email protected]>,
[email protected] says...
>
> 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/ne...ale/index.html

--
Regards,

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