Lognormal base in charts (excel 2007)

[Guest]

This is a difficult technical question.

Excel 2007 allows me to set the base of my lognormal chart (e.g., 2 or 10)
but is there any way that I can make the base dependent on the values in my
worksheet depending on what they are e.g., if my max spreadsheet value is 20
I would like a lognormal base of 2 and if my max spreadsheet value is 1000 I
would like a lognormal base of 10?

Thx.

 

[Jon Peltier]

You would need to use a programmatic approach to this, similar to this
example, but expanded to include the log base.

http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

P.S. it's the logarithmic base, not the lognormal base.

- Jon

 

[Guest]

Many thanks John - by the way does excel 2007 fix all the problems that
other users seemed to have with log graphs, or are there any that remain
unfixed?