+ Reply to Thread
Results 1 to 4 of 4

How do I change the scale of logrithmic curve on the x-axis?

  1. #1
    les
    Guest

    How do I change the scale of logrithmic curve on the x-axis?

    I would like to reduce the x-axis range on a logrithmic curve from 10 to 50,
    but I am restricted to a scale of 10 to 100?

  2. #2
    Forum Contributor
    Join Date
    08-02-2005
    Posts
    102
    A logarithmic scale by definition goes up in decades. You have to use multiples of 10, by this I mean 0.01, 0.1, 1, 10, 100, 1000 etc. You cannot use anything else

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,369
    It's true that Excel's chart engine is limited in this way, but I have seen other graphing programs that do allow you to set logarithmic scales to other than integer powers of 10. Are you in a position to use logarithms on a regular scale (instead of actual values on a logarithmic scale) for your X values?

  4. #4
    Tushar Mehta
    Guest

    Re: How do I change the scale of logrithmic curve on the x-axis?

    In article <853978B9-347C-4EA9-B03C-3AFC85AA770B@microsoft.com>,
    les@discussions.microsoft.com says...
    > I would like to reduce the x-axis range on a logrithmic curve from 10 to 50,
    > but I am restricted to a scale of 10 to 100?
    >

    To simulate the effect see
    Flexible Log Scale
    http://www.tushar-
    mehta.com/excel/newsgroups/flexible_log_scale/index.html

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

+ 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