> hi friends..,
>
[quoted text clipped - 5 lines]
> 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

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