<Iran -- Apocalypse Now?The Oil DrumMonday Open Thread and News Dump>

51 comments on A Gentle Disagreement on Turkmen gas

Comments can no longer be added to this story.

Oil CEO on April 10, 2006 - 1:41am Permalink | Subthread | Parent | Comments top
Stuart, I'v been futzing around with price all night trying to somehow add it to this graph. Unsatified at my attempts to somehow relate the two in a chart that shows promise for a correlation. Any thoughts?
0
Comments can no longer be added to this story.
Stuart Staniford on April 10, 2006 - 1:53am Permalink | Subthread | Parent | Comments top
In Excel, under the Chart Menu, choose "Chart Type".  Select the "Custom Types" tab, and then choose "Lines on 2 Axes".  

Also, if you've already got a chart you can add another series on a second axis somewhere under the Data menu but I forget where.

0
Comments can no longer be added to this story.
Oil CEO on April 10, 2006 - 2:04am Permalink | Subthread | Parent | Comments top
Thanks. Excel isn't the problem I'm having, it's conceptualizing the relationship between price and production.  They move percentage-wise in magnitudes that are incompatible, so you have to dampen the price magnitude by several factors.

I've tried indexing them to a "100" number but then how do you choose what month corresponds to "100" for both except for arbitrarily?

Maybe I'll post some of my best aborted attempts later so you can see what I mean.

Maybe there isn't anything relevent we can draw from the two? Maybe there is, I just can't get a graph to show it.

0
Comments can no longer be added to this story.
Stuart Staniford on April 10, 2006 - 2:12am Permalink | Subthread | Parent | Comments top
That's why you want two axis - it lets you have both variables on difference scales on the same graph.
0
Comments can no longer be added to this story.
Oil CEO on April 10, 2006 - 2:15am Permalink | Subthread | Parent | Comments top
Yeah, you're right, I'm gonna try that next.
0
Comments can no longer be added to this story.