Logarithm scaling for charts

[vroomvondel]

When using logarithmic scaling for charts the scaling interval is given in
powers of 10 (1, 10, 100, 1000 etc). I want to be able to change the scaling
interval to show data at a smaller log. interval (e.g. between 100 and 200).
This is not at present possible in Excel but it would be extremely useful.

 

[rgeorgerian]

When using logarithmic scaling for charts the scaling interval is given in
powers of 10 (1, 10, 100, 1000 etc). I want to be able to change the scaling
interval to show data at a smaller log. interval (e.g. between 100 and 200).
This is not at present possible in Excel but it would be extremely

useful.

Greetings,

There is an explanation regarding your query.

Click on-
http://groups-beta.google.com/group.../36c9fffc1d4abe6c?q=richardg#36c9fffc1d4abe6c

Careful about the word wrap. Or search on richardg.
Best regards,

RichardG

 

[Jon Peltier]

Tushar Mehta shows how to fake this on his web site:

http://tushar-mehta.com/excel/newsgroups/flexible_log_scale/index.html

I've posted several examples of faking specialty axes with extra XY
series on my site, if you need a couple examples to get started:

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

Start with the Arbitrary Axis Scale example, and go from there.

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