+ Reply to Thread
Results 1 to 2 of 2

Line-Graph for consecutive days worked

  1. #1
    Registered User
    Join Date
    07-30-2020
    Location
    Louisville, KY
    MS-Off Ver
    Excel 2007
    Posts
    1

    Line-Graph for consecutive days worked

    I want to make a line graph that depicts consecutive days worked by individual associates over a 31 day period to help with weekend scheduling. 7 associate names per chart, each with an individual line/color so we can quickly see who is highest.

    I have no idea how to go about making this, I have tried several pre-made consecutive work day formulas to no avail, mainly because I need a line graph and not a table.

    If someone could work this out and send me a sample sheet to look at how it's done, I would appreciate it! I'm new here, so if there's a better place to put this thread just let me know.

    *EDIT: I figured out... something. I got values to make sense by making a proxy dataset that is actually being measured by the graph and itself measuring the data on the input dataset, so I can have a simple input system and still get the graph to understand what I need it to do. I even got the 0 values to reset to 0. However, on the next point it doesn't start at 1 again but whatever the previous sum was before the 0 plus the target cell. So you go from working 0 consecutive days to 8 consecutive days in the span of 1 day of time. Not sure how to correct this. Attached for reference. Proxy dataset is scroll-right.
    Attached Files Attached Files
    Last edited by Tadsilverthorn; 07-30-2020 at 03:00 AM. Reason: Updated

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,573

    Re: Line-Graph for consecutive days worked

    Perhaps in your "proxy dataset" use:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    see attached
    Attached Files Attached Files
    Best Regards,

    Kaper

+ 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. Counting consecutive days worked
    By csweezy in forum Excel General
    Replies: 20
    Last Post: 01-04-2020, 12:41 AM
  2. Counting ONLY consecutive days worked starting from a user defined date
    By Tazdude24 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-30-2018, 09:47 PM
  3. Replies: 16
    Last Post: 10-01-2018, 02:02 AM
  4. Creative way to count days worked or average days worked...
    By bcrockett101 in forum Excel General
    Replies: 1
    Last Post: 08-09-2016, 12:16 PM
  5. [SOLVED] Formatting of consecutive days worked
    By ktbb0312 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-23-2015, 05:46 PM
  6. [SOLVED] Average hours worked based on days worked during a pay cycle
    By jaycee66 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-14-2012, 06:27 PM
  7. Replies: 2
    Last Post: 11-05-2011, 07:29 AM

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