logarithmic x-axis with a maximum between 100 and 1000

[Guest]

I have office 2000, Excel. I would like to do a diagram with a logarithmic
x-axis with a maximum between 100 and 1000. Is that possible or do I have to
select an axis maximum that are 10x?

 

[Bernie Deitrick]

Noss,

AFAIK, you are limited to complete decades when using the logarithmic scale on the Y axis.

HTH,
Bernie
MS Excel MVP

 

[Andy Pope]

Hi,

If you use a xy-scatter chart you can enable the log x-axis.

Have a look at Tushar Mehta's flexible log scale for information on
setting non 10x axis values.
http://tushar-mehta.com/excel/newsgroups/flexible_log_scale/index.html

Cheers
Andy