+ Reply to Thread
Results 1 to 4 of 4

Reading values of one variable off the axis of another

  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    7

    Reading values of one variable off the axis of another

    Hello Excel Forum

    I am trying to find the relationship between two variables that have completely different scales.

    I have included below a graph of the two variables plotted over time.

    dual axes plots.jpg

    I want to be able to calculate the periods of time when wind outputs exceed national load outputs (wind > national), however the different scales are prohibitive. If you look at the graph above, at X-value 217, the wind output begins to exceed the national load. This point in time indicates a surplus of wind energy, and at that exact moment (X-value 217), it would be perfect to simply read off the graph on the left hand side where this high wind value meets the second axis for national load, i.e. at around the 28000 mark. This would allow you to work out the total energy over time produced when wind outputs exceed national loads. I need to know the amount of surplus energy produced, (displayed by those periods of time when wind values appear to exceed national loads at least on the graph).

    If anyone has any suggestions as to how to sort this one out, please let me know.

    Thanks guys
    Last edited by FoulFiend; 01-21-2013 at 08:38 AM. Reason: Solved

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Reading values of one variable off the axis of another

    Hi FoulFiend,

    If you have data for both the lines, you can use the MAX function to figure out maximum value easily. Suggest you to upload your data and highlight what you want there. thanks.

    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    09-20-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Reading values of one variable off the axis of another

    Hi dilipandey

    Your suggestion is correct and was exactly the same as my own solution figured out last night whilst lying awake in bed, (lol!). An analysis of the percentage ratios is an entirely effective method of analysis, and allows comparison within the same range values.

    Again, thank you for the suggestion!

    Keep well.

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Reading values of one variable off the axis of another

    You are welcome Foulfiend... cheers

    Suggest you to mark this thread as [SOLVED].. thanks.

    Regards,
    DILIPandey
    <click on below * if this helps>

+ 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