# Reading values of one variable off the axis of another

1. ## 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

2. ## 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>

3. ## 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. ## 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>

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

#### 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