+ Reply to Thread
Results 1 to 3 of 3

Count dates and list as 4 series

  1. #1
    Registered User
    Join Date
    11-20-2013
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Count dates and list as 4 series

    Hi

    I have 4 ranges of dates. I want each of these ranges to be an own series in a graph where they are counted based on number of occurences each month per year (see picture).
    I prefer not to use "CountIF" and instead use Pivot tables if possible.

    In the attached picture you can see what result I want but I was not able to include the 4 date series in the same graph. I think there is a quick fix so I was hoping anyone could help me with what data goes to which pivot data field, and if there are anything else I need to do to solve this problem. If it is not possible using pivot tables I'll just use CountIF.

    Thank you.

    Regards
    Stian
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Xsell; 12-09-2013 at 03:15 PM. Reason: Picture wrong

  2. #2
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Count dates and list as 4 series

    You need to rearrange your data like I did in columns F & G.
    A line graph doesn't look great, with the number of months with no values being quite high for each data group, but if you do a bar graph, and look at a select year, you may get the visual you are looking for.
    Attached Files Attached Files
    Please click the * icon below if I have helped.

  3. #3
    Registered User
    Join Date
    11-20-2013
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Count dates and list as 4 series

    Thank you very much, just what I needed!

+ 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. How to count names from diferent list of dates
    By gavitia in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-18-2013, 02:06 PM
  2. Replies: 3
    Last Post: 02-16-2012, 01:51 PM
  3. count values from same dates in list (without VBA)
    By BartDeHertogh in forum Excel General
    Replies: 3
    Last Post: 02-19-2010, 10:37 AM
  4. Charting count of unique dates in a list
    By [email protected] in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 06-06-2006, 09:35 AM
  5. need to convert list of dates to count no. of dates by week
    By neowok in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-30-2006, 11:54 AM

Tags for this Thread

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