+ Reply to Thread
Results 1 to 5 of 5

Gantt Chart Using Macros

  1. #1
    Registered User
    Join Date
    04-25-2019
    Location
    colombo
    MS-Off Ver
    2007
    Posts
    12

    Lightbulb Gantt Chart Using Macros

    Hi All,
    I think this is a new thing.I made a new gantt chart to show about the usage of machines in a factory. So think factory have 40 Machines for knitting, and people need to manage those machines for their knit. so using this gantt chart worker and managers can know about which machine using for which hours. 1 machine can use only one person at a time. The problem is i dont know how to represent 2 data for 1 cell. some machine start to knitting 9.00 AM to 1.00 PM and another user get that machine and knit from 1.00 PM to 5.00PM so it need to colour 1.00PM cell twice. its overlapping.so i think to resolve this from 1 cell dividing left corner for start relevant hour and right corner for ending that hour, but i dont know how to modify this code. Please help me .!!!

  2. #2
    Registered User
    Join Date
    04-25-2019
    Location
    colombo
    MS-Off Ver
    2007
    Posts
    12

    Re: Gantt Chart Using Macros

    Here i attached relevant worksheet.
    Last edited by jani11; 05-02-2019 at 03:00 AM.

  3. #3
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Re: Gantt Chart Using Macros

    Try adding an additional column 12.59pm this would allow you to finish one colour at 12:59 pm and start another at 1:00 pm

    I am not sure you can split a cell with 2 colours

  4. #4
    Registered User
    Join Date
    04-25-2019
    Location
    colombo
    MS-Off Ver
    2007
    Posts
    12

    Re: Gantt Chart Using Macros

    Hi, Excelski

    yes i cant split same cell with two colours. i dont have idea where should i modify

  5. #5
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Re: Gantt Chart Using Macros

    I cant help you with vba sorry

+ 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] Timeline Gantt chart - Chart bars are in reverse order
    By gan_xl in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-20-2019, 01:02 PM
  2. [SOLVED] Have the ability to view a daily Gantt chart as a monthly gantt chart
    By adam_d_john in forum Excel General
    Replies: 3
    Last Post: 03-13-2018, 09:11 PM
  3. Replies: 0
    Last Post: 01-07-2015, 01:22 PM
  4. Macros color cells to make something as gantt chart
    By karbidas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2014, 09:22 AM
  5. Replies: 5
    Last Post: 10-04-2012, 07:01 AM
  6. Replies: 0
    Last Post: 07-13-2012, 06:40 PM
  7. GANTT chart based on conditional formatting - macros to merge cells
    By Florinnn in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-25-2010, 12:21 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