+ Reply to Thread
Results 1 to 2 of 2

Graphing Well count by Year.. Help!

  1. #1
    Registered User
    Join Date
    07-15-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    9

    Graphing Well count by Year.. Help!

    So i have a huge database.

    Each row is a well.

    The column I am working with currently is completion date. I have sorted the wells by completion dates. Dates are listed in format 5/20/2012.

    I need to make a graph showing the number of wells by year.

    Basically, x axis is the year and y axis is the number of wells completed that year.

    Can someone walk me through this?

    Thank you!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Graphing Well count by Year.. Help!

    Perhaps create a Pivot Table then a Pivot Chart based on the table ?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count/No Count for year entered---formula help
    By awest181 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-26-2012, 02:07 PM
  2. [SOLVED] Count days for specific year falling within in multi-year date range
    By jslo2013 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-04-2012, 05:58 PM
  3. [SOLVED] Graphing data based on COUNT
    By davidJIBS in forum Excel General
    Replies: 6
    Last Post: 04-07-2012, 04:24 AM
  4. Graphing a Count within date range
    By Jimmy1214 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-10-2008, 03:26 PM
  5. [SOLVED] Graphing-Two stacked columns side-by-side per year
    By brwneyeirishlady in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-30-2006, 03:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1