+ Reply to Thread
Results 1 to 3 of 3

Need to Chart occurrences over Time

Hybrid View

  1. #1
    Registered User
    Join Date
    01-16-2014
    Location
    South Dakota, United States
    MS-Off Ver
    Excel 2007, 2010
    Posts
    2

    Question Need to Chart occurrences over Time

    I am new to the forum and looking forward to learning on here. I need to use excel on a daily basis at my new job and want to become more efficient.

    7-Jun tf
    7-Jun non
    8-Jun tf
    8-Jun non
    8-Jun tf
    9-Jun non
    9-Jun non
    9-Jun non
    9-Jun tf
    10-Jun non
    11-Jun tf
    12-Jun non

    This is a very simplified version of what I need to graph but has the variables I need. The spreadsheet is set up just like this, just extrapolated over the last year. There are over 500 entries in the spreadsheet. What I need to do is to be able to calculate and chart the number of occurrences of TF and Non over time, by day, month, and year. If the data is ordered by date, how can I get excel to calculate text occurrences and graph them over the dates? Thanks everyone!

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    27,050

    Re: Need to Chart occurrences over Time

    You can do this with a pivot chart. If you attach your file we can put one in there. Meantime there are tons of material available if you search on "Excel pivot chart", and also try looking at Excel Help.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    01-16-2014
    Location
    South Dakota, United States
    MS-Off Ver
    Excel 2007, 2010
    Posts
    2

    Re: Need to Chart occurrences over Time

    Alright I will give it a shot. Thanks!

+ 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. Cannot Publish Excel Pivot Chart - Run Time Error
    By crisb184 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2013, 07:04 AM
  2. Replies: 0
    Last Post: 07-24-2013, 04:35 PM
  3. Occurrences between different time periods
    By gvaltat in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-01-2013, 01:49 PM
  4. Count time occurrences across multiple sheets
    By Lea724 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-14-2011, 09:03 AM
  5. SLA vs Time Taken Chart
    By thoemmes in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-06-2005, 10:13 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