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!