+ Reply to Thread
Results 1 to 3 of 3

Logarithm scaling for charts

  1. #1
    vroomvondel
    Guest

    Logarithm scaling for charts

    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.

  2. #2

    Re: Logarithm scaling for charts

    vroomvondel wrote:
    > 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/...c9fffc1d4abe6c

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

    RichardG


  3. #3
    Jon Peltier
    Guest

    Re: Logarithm scaling for charts

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

    http://tushar-mehta.com/excel/newsgr...ale/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/
    _______

    vroomvondel wrote:

    > 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.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1