+ Reply to Thread
Results 1 to 4 of 4

Help pls, to create a histogram using time and minutes data.

  1. #1
    Registered User
    Join Date
    05-26-2016
    Location
    New Zealand
    MS-Off Ver
    2010
    Posts
    3

    Help pls, to create a histogram using time and minutes data.

    Hi, I am trying to create a histogram / block graph style visual aid to predict workload and overload periods for a theatre recovery suite (PACU) in a small hospital. There are several theatres all delivering patients to a single recovery room (PACU) with 2 or 3 or more staff working in. There are times of low throughput and times of excessive workload when a few patients exit theatre at similar times causing problems.
    The problem is that (I am very new to excel and have got so far by youtube and this forum) I cannot extract the data from the sheet to convert into a visual aid to enable the theatre operations to be juggled, to gain a more even workload throughout the day.
    I need to show the working day in hours on X axis from 0700 – 2359hrs and staff numbers on Y axis 1 -6.
    Info.
    Each member of staff is one to one with a patient for the duration of the PACU stay.
    A long operation results in a longer recovery time so there may be a patient that spends 2 or 3 hours in recovery (PACU) after a lengthy morning operation and then the 3 other theatres may output 3 patients together and therefore, a peak is produced so a normal team of 2 or 3 then requires other members of staff to scrub and gown up for the duration of the peak until 1 out of the 4 patients in recovery is then discharged to another department. Data to be taken from PACU ARRIVE and PACU DURATION MINS
    Hope that makes sense.
    Thanks in advance, and keep replies simple and idiot proof!!!

    PACU Loading.jpg

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Help pls, to create a histogram using time and minutes data.

    Any chance we could see the data in a workbook rather than the attached image?
    Much easier to work with that way.

    BSB

  3. #3
    Registered User
    Join Date
    05-26-2016
    Location
    New Zealand
    MS-Off Ver
    2010
    Posts
    3

    Re: Help pls, to create a histogram using time and minutes data.

    Sorry, tried to upload worksheet but to no avail. Spent 2 hrs last night and another hour this morning.
    Followed the 'attach tutorial.docx' closely and have tried a plethora of settings, Firefox, Chrome, IE. cookies, Virus protection etc etc
    I get to 'close window' after upload (all good) and then the upload does not show up in the 'manage attachments' area.

    Still hope you can offer some advice though. Kind regards Pete
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    05-26-2016
    Location
    New Zealand
    MS-Off Ver
    2010
    Posts
    3

    Re: Help pls, to create a histogram using time and minutes data.

    Oh there you go, it appeared as if by magic. Ive been having troubles with this PC ever since it crapped out and my son rebuilt it a couple of years ago then that is where the problems started, I should have just bought a new one. Thought it was that.

+ 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. making histogram from data vs time
    By rudy van eekelen in forum Excel General
    Replies: 1
    Last Post: 05-15-2016, 12:11 AM
  2. HOW CAN I CREATE A HISTOGRAM GRAPH FOR MY DATA?
    By NNAMDI in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-10-2006, 03:30 PM
  3. How to Histogram w/o raw data but histogram Table on Excel
    By 2005 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-01-2006, 02:50 AM
  4. [SOLVED] Is it possible to create a histogram from data in excel?
    By rantz in forum Excel General
    Replies: 1
    Last Post: 01-16-2006, 08:15 AM
  5. create formula to add 15 minutes to previous time value
    By Bruce in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-02-2005, 06:20 PM
  6. create formula to add 15 minutes to previous time value
    By Bruce in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-02-2005, 06:17 PM
  7. How do I create a range of the BIN in a Data Analysis Histogram?
    By Histogram in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-17-2005, 12: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