Working with Dates and "Active Wells".... HELP! very confusing!

**texas979** · 2013-07-17, 02:48 AM

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!