+ Reply to Thread
Results 1 to 6 of 6

Digitizing a logarithmic graph

  1. #1
    Registered User
    Join Date
    09-08-2014
    Location
    -
    MS-Off Ver
    -
    Posts
    68

    Digitizing a logarithmic graph

    Greetings,
    I've been tasked with digitizing the following graph:

    Original Graph.png

    There are quite a few tools which allow one to calibrate axes and then get a series of points.
    I have done this, and I have a data series for each curve. I've put them together on a scatter graph, yielding the following result:

    Untitled.png

    However, the issue is that the y-axis scale is different on the original image. Some measuring has shown that the distance between 1 and 2 is roughly equal to the distance between 2 and 4 so it's base 2 of some sort, but I have no idea how to replicate the original scaling.
    If I set the y-axis as being logarithmic on Excel, I get a bunch of negative values as the original points I got go below one.
    To top it off, technically the original points were already logarithmized (I'm assuming that's a word) - so technically I don't need to perform any mathematical operations on it, just have the scale not be linear.

    Any suggestions?

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,980

    Re: Digitizing a logarithmic graph

    Applying a log scale axis doesn't apply any mathematical operations to the data it simply distorts the axis. You can use a base 2 log, but it will be impossible to get the axis to plot from 0. You'd have to use a dummy series to plot the axis labels, I think.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Registered User
    Join Date
    09-08-2014
    Location
    -
    MS-Off Ver
    -
    Posts
    68

    Re: Digitizing a logarithmic graph

    Oh God. I thought it had made a bunch of negative values because it shoved the x-axis up to y = 1. I can't have the x-axis go to 0 but I can have it at 0.0000000001 Thanks!

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Digitizing a logarithmic graph

    Hi,

    I suppose the first thing to do is establish why you've got negative points since the original doesn't show any - least not on the chart.

    Are you sure you're not confusing the position of the x axis and the implication that points below this are negative. The x axis probably by default is showing alongside point 1 on the y axis. Set the x axis labels to 'Low' so that the x axis is at the foot of the chart.

    Upload the actual workbook if you need more specific help.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  5. #5
    Registered User
    Join Date
    09-08-2014
    Location
    -
    MS-Off Ver
    -
    Posts
    68

    Re: Digitizing a logarithmic graph

    Quote Originally Posted by Richard Buttrey View Post
    Hi,

    I suppose the first thing to do is establish why you've got negative points since the original doesn't show any - least not on the chart.

    Are you sure you're not confusing the position of the x axis and the implication that points below this are negative. The x axis probably by default is showing alongside point 1 on the y axis. Set the x axis labels to 'Low' so that the x axis is at the foot of the chart.

    Upload the actual workbook if you need more specific help.
    Right, so I've kind of sorted it out; here's the result:
    Result.png

    I wanted to use polynomial trendlines (I mean the originals are almost perfect parabolas so...) to tidy it up.
    Now before changing the scale to logarithmic, the trendlines look really great.
    However once I logarithmize (I'm making this a word.) the scale, they become...not so good.
    Trendlines.png
    Is that just the nature of my data?

  6. #6
    Registered User
    Join Date
    09-08-2014
    Location
    -
    MS-Off Ver
    -
    Posts
    68

    Re: Digitizing a logarithmic graph

    Never mind guys! I'm reacquiring the data sets and getting much smoother curves - thanks for all your help, truly appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 10-07-2013, 11:41 AM
  2. [SOLVED] Logarithmic Scale
    By dr_phd1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-23-2013, 12:13 PM
  3. Double x axis with logarithmic scale in scatter graph
    By gpktm in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-31-2007, 02:57 PM
  4. [SOLVED] Logarithmic plotting
    By dieseldan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-01-2006, 02:40 PM
  5. logarithmic regression
    By lcoddens in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-08-2006, 02:35 PM

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