+ Reply to Thread
Results 1 to 2 of 2

Create semi-log plot for percentage

  1. #1
    Registered User
    Join Date
    12-21-2005
    Posts
    1

    Red face Create semi-log plot for percentage

    Good morning,

    I have exhausted myself searching the internet for a way to create this graph. I am really hoping that someone on this forum will help me.

    I am trying to make a (reverse??) semi-log plot with the y-axis to display 0.9, 9, 99, 99.9, 99.99%. On the x-axis I want concentrations of 0.0, 0.01, 0.05, 0.10, 0.25.

    I have used the scatter plot with the logarithmic funchtion selected...but that gives me 10,100,1000....I can seem to figure out how to get it to do what I need.

    Thank you in advance to anyone who replies!

    galgocid

  2. #2
    Tushar Mehta
    Guest

    Re: Create semi-log plot for percentage

    You can 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

    In article <galgocid.20ec3y_1135179003.044@excelforum-nospam.com>,
    galgocid.20ec3y_1135179003.044@excelforum-nospam.com says...
    >
    > Good morning,
    >
    > I have exhausted myself searching the internet for a way to create this
    > graph. I am really hoping that someone on this forum will help me.
    >
    >
    > I am trying to make a (reverse??) semi-log plot with the y-axis to
    > display 0.9, 9, 99, 99.9, 99.99%. On the x-axis I want concentrations
    > of 0.0, 0.01, 0.05, 0.10, 0.25.
    >
    > I have used the scatter plot with the logarithmic funchtion
    > selected...but that gives me 10,100,1000....I can seem to figure out
    > how to get it to do what I need.
    >
    > Thank you in advance to anyone who replies!
    >
    > galgocid
    >
    >
    > --
    > galgocid
    > ------------------------------------------------------------------------
    > galgocid's Profile: http://www.excelforum.com/member.php...o&userid=29814
    > View this thread: http://www.excelforum.com/showthread...hreadid=495189
    >
    >


+ 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