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

T

texas979

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 fro
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 ste
by step
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top