+ Reply to Thread
Results 1 to 2 of 2

Labor Productivity with Labor and Covers by Hour

  1. #1
    Registered User
    Join Date
    02-24-2019
    Location
    Las Vegas
    MS-Off Ver
    Office 16
    Posts
    4

    Labor Productivity with Labor and Covers by Hour

    Hi, this should be an easy one to figure out but I have a lot on my plate and can't take the time to figure it to work correctly. I am trained as a Chef FYI, have to learn everything in excel on my own (and awesome people who post on forums!).

    I need a graph that has bars and lines on it as follows:

    Y axis needs to have total covers, people who came and ate and/or plates sold
    X axis needs to be labeled as times and needs to be by the hour

    500

    400

    300

    200

    100

    0
    9am 10am 11am 12pm 1pm 2pm 3pm 4pm 5pm

    Now this is simple enough to lay out in a bar graph, but I can't figure out how to get a line graph overlapping this showing total number of labor hours. It has to be super simple for a Chef to enter in the information. They would be responsible for entering in the labor hours and the total covers on any given day.


    TIME ll Covers ll Labor Hours
    9am 250 8
    10am 250 8
    11am 300 16
    etc

    Any additional help would be greatly appreciated and would also be given a free hamburger when visiting Las Vegas in the future!


    Thank You,
    Chef Thomas

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    11,205

    Re: Labor Productivity with Labor and Covers by Hour

    Using the time, covers and hrs data from post #1 a chart combo column/line graph could be produced by:
    1. Selecting one cell in the data and using the key combination Ctrl + n + r
    2. Select the cluster column graph
    3. Right click on one of the hrs. columns
    4. Select change series chart type
    5. Select line and also select secondary axis
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Need to itemize labor
    By flynfarm in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-29-2018, 06:23 PM
  2. calculating sales per labor hour as of current time.
    By Robt1973 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-09-2016, 06:02 PM
  3. [SOLVED] Calculate Labor Hours by Hour
    By theshaner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-26-2013, 06:15 PM
  4. Replies: 3
    Last Post: 10-02-2012, 03:30 PM
  5. Labor and Cost
    By rtfreema in forum Excel General
    Replies: 3
    Last Post: 09-22-2011, 08:16 AM
  6. Labor day formula
    By Richard in forum Excel General
    Replies: 3
    Last Post: 07-12-2006, 08:45 AM
  7. [SOLVED] Labor Rate %
    By Myrna in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-27-2005, 10:00 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