View Single Post
  #1   Report Post  
texas979 texas979 is offline
Junior Member
 
Posts: 1
Default Working with Dates and "Active Wells".... HELP! very confusing!

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
The first column is the year the well was first active.
The second column shows the year the well was last active.

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!