Excel 2010 Tables
No VBA
http://www.mediafire.com/download/2m...07_16_13a.xlsx
Year First Active
Year Last Active
1982 2013 1983 2013 1983 2003 1983 1988 1984 2013 1984 2013 1984 2013 1984 2013 1984 1997 1984 1990 1985 2013 1985 2013 1985 2013 1985 2013 1985 2013 1985 2013 1985 2013 1985 2000 1985 2000 1985 1991 1985 1988 1985 1987 1986 2013 1986 2013 1986 2013 1986 2011 1986 1989 1987 2013
Each row above is a different well
I need to make a graph with the data above.
Basically, the x axis needs to be years.
(1982, 1983, 1984...........2012, 2013)
The y axis needs to be the number of ACTIVE wells each year.
For example, the very last well (last row of data) was active from 1987-2013.
And the one before that was active 1986-1989
How can i represent the number of wells that were active each year?
Thank you!
i dont know ANY vba, so if you suggest using vba, please guide me step by step!
Excel 2010 Tables
No VBA
http://www.mediafire.com/download/2m...07_16_13a.xlsx
Thanks!
Bookmarks