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.

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/...nkToSheet.html

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"jonny" wrote in message
...
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.

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?

"Jon Peltier" wrote:

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/...nkToSheet.html

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"jonny" wrote in message
...
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.