+ Reply to Thread
Results 1 to 3 of 3

Time Line based gannt chart

Hybrid View

  1. #1
    Registered User
    Join Date
    02-02-2014
    Location
    indore
    MS-Off Ver
    Excel 2007
    Posts
    2

    Time Line based gannt chart

    Hello all,

    i have some data, bassicly they are start and stop time of two machine over a period of 24 hrs everday. what i require is creat a gannt chart of two machine on single time line of x axis from 00:00 to 23:59 and y axis should have machine id.

    |
    |
    Machine i1 | _______________ _____________
    |
    Machine i2 | ______________ __________
    ---------------------------------------------------------------------------------------------- Should be stacked bar
    00:00 06:00 22:00 23:59

    Data : ID Start Stop
    1 00:30 1:30
    2 02:00 02:30
    1 03:00 04:00
    1 04:20 04:50
    2 05:00 05:50
    at a time only machine will run in given time .

    Please help in this regard,

    Regrads,
    Manish

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: Time Line based gannt chart

    As stated in forum rules:
    Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    02-02-2014
    Location
    indore
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Time Line based gannt chart

    sorry i still cant attach my sheet, however i am posting the data.

    PLANTStart Time End Time
    CON2 21:54 22:15
    CON1 22:42 23:05
    CON1 23:09 23:37
    CON2 23:41 00:31
    CON1 00:34 01:21
    CON2 01:30 02:03
    CON2 02:07 02:23
    CON2 02:28 02:37
    CON1 02:40 02:57
    CON1 03:02 03:16
    CON1 03:23 03:38
    CON1 03:42 04:04
    CON2 04:09 04:35
    CON2 04:40 05:14
    CON1 05:18 05:43
    CON1 05:47 06:01
    CON1 06:06 06:30
    CON2 06:35 07:38
    CON1 07:48 08:35
    CON2 08:39 09:15
    CON2 09:16 09:36
    CON1 09:39 10:12
    CON1 10:14 10:34
    CON2 10:39 11:29
    CON1 12:04 12:37
    CON1 13:43 14:11
    CON2 14:15 14:31
    CON1 14:45 15:04
    CON2 15:13 15:51
    CON1 15:55 16:11
    CON1 16:16 16:33
    CON2 16:37 17:16
    CON2 17:20 17:35
    CON2 17:39 17:54
    CON1 17:57 18:12
    CON1 18:18 18:47
    CON1 18:52 19:00
    CON2 19:14 19:28
    CON2 19:36 19:50
    CON2 19:55 20:03
    CON1 20:06 20:14
    CON1 20:20 20:33
    CON1 20:42 20:54
    CON1 21:02 21:15
    CON1 21:22 21:28
    CON2 21:32 21:46

+ 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. Create a self filling GANNT Chart
    By IbbAS in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-23-2013, 12:12 PM
  2. Construction Schedule or Gannt Chart
    By lorber123 in forum Excel General
    Replies: 3
    Last Post: 11-23-2012, 04:35 PM
  3. Problem with dates in a Gannt chart - please help
    By ricardomartinez in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-01-2012, 10:46 AM
  4. Steps Needed-Gannt Chart
    By clintongj in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-19-2009, 07:44 AM
  5. [SOLVED] how do i create gannt chart in excell?
    By Deepak in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-07-2006, 07:40 AM

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