When I create a XY Scatter chart and tell XL to show the x-axis on a
log scale I get 1, 10, 100, 1000 as the 1st, 2nd, 3rd, and 4th markers.
Dunno how you are getting 2001 as the 20th tick mark.

In any case, you might want to check 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

In article ,
says...
I recently generated a spiffy Log Chart:--

The x-axis (linear) scale doesn't format how I want it to look:
"1" is displayed under the y-axis, then "1001" at the 10th tick mark, "2001"
at the 20th tick mark, etc. I want 0,1000,2000, . . . to be displayed. Yes,
log(0) is undefined. So what. I'm not asking to see a value plotted on the
y-axis, I just want my chart to look decent.

I'm curious if Excel can display log scaling correctly?

Thanks for your help!

Mike