logarithmic scale
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: logarithmic scale

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a problem which I can't figure out how to solve: I have som data in the range 10 000 to 40 000 and I want to present then in a (x,y)-diagram (I have years from 1980 till 1990 on the x-axis) with logarithmic scale (10-log). But when I choose that, the y-axis will automatically be from 10 000 to 100 000. I would like to have the y-axis from 10 000 to 40 000 and with gridlines between with the numbers 15 000, 20 000, 25 000, 30 000 and 35 000 (which then of course have different length between them). Is this possible? Can I program it in Visual Basic perhaps?
    I really would appreciate your help.
    Yours Sincerely
    Lone Christensen

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-19 04:32, lone wrote:
    I have a problem which I can't figure out how to solve: I have som data in the range 10 000 to 40 000 and I want to present then in a (x,y)-diagram (I have years from 1980 till 1990 on the x-axis) with logarithmic scale (10-log). But when I choose that, the y-axis will automatically be from 10 000 to 100 000. I would like to have the y-axis from 10 000 to 40 000 and with gridlines between with the numbers 15 000, 20 000, 25 000, 30 000 and 35 000 (which then of course have different length between them). Is this possible? Can I program it in Visual Basic perhaps?
    I really would appreciate your help.
    Yours Sincerely
    Lone Christensen
    Why are you intent on using a logarithmic scale on the y-axis? What's the nature of these values?

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,
    You need to format the axis.
    Place your cusor over the y axis. Left click
    This should open the format axis dialog box.
    select the scale tab.
    Uncheck the auto box against maximum and minimum and enter the values you want.
    You can also select the values for the intervening ticks.

    Good Luck


  4. #4
    Board Regular eliW's Avatar
    Join Date
    Mar 2002
    Posts
    1,919
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-04-19 08:22, Lewis wrote:
    Hi,
    You need to format the axis.
    Place your cusor over the y axis. Left click
    This should open the format axis dialog box.
    select the scale tab.
    Uncheck the auto box against maximum and minimum and enter the values you want.
    You can also select the values for the intervening ticks.

    Good Luck

    It seems that minimum and maximum in logarithmic scale are set automatically to n^10 intervals, and there is no way to choose values inbetween.
    Eli

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com