+ Reply to Thread
Results 1 to 2 of 2

Create a chart for rotation of people and respective places based on dates

  1. #1
    Registered User
    Join Date
    06-06-2018
    Location
    Porto Alegre, Brasil
    MS-Off Ver
    2016
    Posts
    1

    Create a chart for rotation of people and respective places based on dates

    Hello all,

    I need to create a chart to organize myself with the rotation dates of the people that work for me.
    It is a rotation for the techinical team in a cruise line, so with the ships in one axis and the date in the other I would like to complete the chart with the
    start and end of the people's contract and the duration so it is easier to visualize.
    Attached is some of the things I was trying.

    Please if anyone can help.
    Attached Files Attached Files

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Create a chart for rotation of people and respective places based on dates

    Hello,

    if you want to visualise this, you can only have dates on the horizontal, not names. For each ship you need to calculate the number of days for the first gap from the start date of the chart, the number of days for the first tour, the next gap, the next tour, etc. With the source data arranged by name in columns, this is difficult to extract.

    That will give you a Gantt chart for the ships' tours, but you will still need to manually set the bar colours to the person's colour. This is not easy to automate.

    A Gantt chart like this is easy to produce when each row has the same phases and you want to see when the phases happen. The phases occur in the same order in each row.

    What you want is not doable with a Gantt chart, since the gaps and the bars are not in the same order for each row.

+ 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. Replies: 6
    Last Post: 10-07-2015, 04:29 PM
  2. How to create automated rotation based roster for students
    By sriharsha4 in forum Excel General
    Replies: 2
    Last Post: 08-26-2015, 01:35 AM
  3. Excel macro to create new workbook based on category in list with respective sheets
    By vadivel77 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-10-2014, 10:42 PM
  4. rotation schedule 5 people with every other friday off
    By golflnkstr in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-03-2014, 10:28 AM
  5. [SOLVED] VBA help need to highlight the cells based on the dates and insert respective cell values.
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-24-2014, 11:14 PM
  6. Replies: 2
    Last Post: 10-24-2013, 11:01 AM
  7. How do I create a commission chart based on dates worked?
    By Orange Pegs in Cerritos in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-03-2006, 08:20 PM

Tags for this Thread

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