Employee Schedule not plotting properly - chart type / data series not correct

Discussion in 'Excel Charting' started by rbrookov, May 7, 2013.

  1. rbrookov

    rbrookov Guest

    Hello,

    Attached is my spreadsheet (SHIFT_COMPARE) which is supposed to plot th
    work hours that employees are scheduled to work vs the day they ar
    working, on a weekly basis.

    It consists of 3 worksheets: "Const", "Sched", & "Chart".

    "Const" = a "back end" sheet containing constants & raw data which
    used to create static & dynamic ranges

    "Sched" = the data sheet where the manager will select the employee
    choose that employee's start time & day(s) they are requested to work

    "Chart" = the output of "Sched" in a visual chart showing eac
    employee's work schedule per day and time, on a weekly basis.

    For this example, all I'm showing is an abbreviated version of "Sched
    (in reality, the work days & shifts are 24/7)

    Anyway, I'm having difficulty presenting the chart the way I want it t
    be presented.

    For instance, if Emp1 is scheduled to work on Sun from 7:00 AM to 3:0
    PM, I want it to show a bar for Emp1 starting on Sun (X-axis) from 7:0
    AM on the Y-axis & goes to 3:00 PM on the Y-Axis. (and likewise for al
    other Employees & their respective work schedules).

    However, it seems to be starting each employee from 12:00 Midnigh
    (rather than their correct start time), as well as plotting the Star
    Time (i.e, "7:00 AM") as one point vs Midnight and the End Time (ie
    3:00 PM) as another point vs Midnight - obviously it should plot it a
    one bar going from 7:00 AM to 3:00 PM, and appropriately for eac
    additional day worked, as well as appropriately for each employee.

    I'm pretty sure this has to do w/ Excel choosing the data in a serie
    that I'm not wanting - but I'm not sure how to fix it?

    While I'm "begging" for help, 1 other (minor, albeit annoying) issue:

    1.) the legend creates instances for all employees, regardless o
    whether they have been scheduled to work that week or not (in my exampl
    Employee 4 is not scheduled to work at all, yet he shows up in th
    Legend).

    Any & all help provided will be most appreciated.

    Thank you,
    Rob
    Excel 2003, SP

    +-------------------------------------------------------------------
    |Filename: SHIFT_COMPARE.zip
    |Download: http://www.excelbanter.com/attachment.php?attachmentid=869
    +-------------------------------------------------------------------


    --
    rbrookov
     
    rbrookov, May 7, 2013
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Annoyed by Excel

    Graph not plotting what it should be plotting

    Annoyed by Excel, Sep 4, 2003, in forum: Excel Charting
    Replies:
    2
    Views:
    282
    Jon Peltier
    Sep 5, 2003
  2. Big Red

    Plotting different length series in a chart

    Big Red, Dec 8, 2004, in forum: Excel Charting
    Replies:
    2
    Views:
    82
    Leo Bueno
    May 5, 2005
  3. rich zielinski via OfficeKB.com

    series graph -- one series being added to another series

    rich zielinski via OfficeKB.com, Mar 28, 2005, in forum: Excel Charting
    Replies:
    3
    Views:
    300
    rich zielinski via OfficeKB.com
    Mar 30, 2005
  4. Barb Reinhardt
    Replies:
    1
    Views:
    143
    Barb Reinhardt
    Oct 4, 2005
  5. Bruce

    Scatter chart not plotting correct range

    Bruce, Oct 7, 2006, in forum: Excel Charting
    Replies:
    1
    Views:
    128
    Jon Peltier
    Oct 7, 2006
  6. Mike
    Replies:
    5
    Views:
    107
    David Biddulph
    Feb 7, 2007
  7. Dhananjay

    Plotting multiple data series in a bubble chart

    Dhananjay, Aug 22, 2007, in forum: Excel Charting
    Replies:
    1
    Views:
    141
    Del Cotter
    Aug 22, 2007
  8. bikash
    Replies:
    0
    Views:
    221
    bikash
    Jan 17, 2008
Loading...