Chart Help!

[rockchalk33]

Needing to create a line graph showing oil production data for each month across several years. The way the data was logged included Jan-Dec as column headings and years 1986-2015 as row headings. How can I graph this data starting with January of 1986 and ending with December of 2015 across the X-axis and the actual production data shown on the y-axis?

Example below:

January February March April...............December
1986 4820 12000 30000 50000
1987 200 3000 5000 60000
.
.
.
.
.
2015


Thank you,
Devin

 

[easy2understandexcel]

You need to put it in a single row or column. You can probably do it manually pretty quickly with cut and paste, but ill show you a formula just for giggles.
On a blank sheet:
In column A, number 0 through 99 starting in A1 and down.
In column B. number 1 through 11, repeating, starting in B1 and down
In column C, =ROUNDDOWN(A1/12,0) starting in C1 and down
In column D, =OFFSET(Sheet1!$X$1,C8,B8,1,1) starting in D1 and down <-- [ change sheet1!$X$1 to be the sheet and cell for January 1986 ]

 

[rockchalk33]

Right on,

Thanks for the help. I'll be sure to try this.