+ Reply to Thread
Results 1 to 1 of 1

One More Charting Question: Best way to show days late/early/on time on a chart?

  1. #1
    Registered User
    Join Date
    06-29-2017
    Location
    USA
    MS-Off Ver
    Office 2016
    Posts
    76

    Smile One More Charting Question: Best way to show days late/early/on time on a chart?

    Hi

    I have a sample of data that's pivoted to show the quantity of people that are On Time, Early, or Late (See attached file with included chart). Basically I'm giving a % of each in table format (late, on time, early), but I also want a chart so that the viewer gets a sense of HOW late or early each person was in terms of days. So notice on the chart that most people are clustered around 0 days late/early, and very few are late after ~ 9 days. But the problem I see is that the ends of the spectrum (15+ days early or 40+ days late) you can't see the breakdown of that. Extending the axis to include them is possible but makes it less clear. Any ideas?

    Is there a completely different/better way to represent this data using a different kind of chart? Keep in mind this is pivoted to be in this format, the actual source data is basically just two columns of lots of dates (each row is a person). The dates are subtracted to get the number of days, and then another column defines it as early/late/on time based on criteria of positive/negative/0 days difference.

    Any thoughts?

    Thanks!!!
    Attached Files Attached Files

+ 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] Pivot Report To Show On Time, Late and Early Data
    By rahul_ferns76 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-04-2017, 08:57 AM
  2. On time, late, early if statement
    By TehJonny in forum Excel General
    Replies: 3
    Last Post: 04-05-2016, 05:05 AM
  3. [SOLVED] Sorting as per Days Late & Days Early
    By simran555 in forum Excel General
    Replies: 4
    Last Post: 01-07-2016, 11:50 AM
  4. [SOLVED] Graph to chart how many times different vendors are early, on time, or late...
    By ekf23 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-18-2014, 03:46 PM
  5. Replies: 2
    Last Post: 02-10-2013, 05:17 PM
  6. [SOLVED] formular that will calculate number of days late or early
    By SOUT in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-09-2012, 04:49 PM
  7. Calculating # of days early or late
    By ssmith0011984 in forum Excel General
    Replies: 4
    Last Post: 09-11-2008, 04:05 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