Logarithm scaling for charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
vroomvondel said:
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
Click to expand...
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
 
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/
_______
 
Back
Top