+ Reply to Thread
Results 1 to 2 of 2

Excel gantt chart for multiple times per day

  1. #1
    Registered User
    Join Date
    04-06-2012
    Location
    Lahore
    MS-Off Ver
    Excel 2007
    Posts
    1

    Excel gantt chart for multiple times per day

    Hi All....

    i am having problem related to Gantt chart in excel 2007. i have pasted my data below.

    Event Date Event Time Cease Date Cease Time Alarm Type Alarm Text
    3/30/2012 1:59:00 3/30/2012 2:54:00 EXTERNAL ALARM AC MAINS FAILURE
    3/30/2012 2:00:00 3/30/2012 2:56:00 INTERNAL ALARM MAINS FAILURE
    3/30/2012 5:07:00 3/30/2012 5:58:00 EXTERNAL ALARM AC MAINS FAILURE
    3/30/2012 5:08:00 3/30/2012 6:00:00 INTERNAL ALARM MAINS FAILURE
    3/30/2012 8:03:00 3/30/2012 8:43:00 EXTERNAL ALARM AC MAINS FAILURE
    3/30/2012 8:04:00 3/30/2012 9:01:00 INTERNAL ALARM MAINS FAILURE
    3/30/2012 8:43:00 3/30/2012 8:59:00 EXTERNAL ALARM GENSET STOPPED BY VTDC
    3/30/2012 8:43:00 3/30/2012 8:59:00 EXTERNAL ALARM AC MAINS FAILURE
    3/30/2012 8:59:00 3/30/2012 9:00:00 EXTERNAL ALARM GENSET STOPPED BY VTDC
    3/30/2012 11:06:00 3/30/2012 11:49:00 EXTERNAL ALARM AC MAINS FAILURE
    3/30/2012 11:07:00 3/30/2012 11:51:00 INTERNAL ALARM MAINS FAILURE
    3/30/2012 14:00:00 3/30/2012 14:56:00 EXTERNAL ALARM AC MAINS FAILURE
    3/30/2012 14:01:00 3/30/2012 14:58:00 INTERNAL ALARM MAINS FAILURE
    3/30/2012 15:58:00 3/30/2012 16:47:00 EXTERNAL ALARM AC MAINS FAILURE
    3/30/2012 16:00:00 3/30/2012 17:01:00 INTERNAL ALARM MAINS FAILURE
    3/30/2012 16:47:00 3/30/2012 16:59:00 EXTERNAL ALARM AC MAINS FAILURE
    3/30/2012 16:47:00 3/30/2012 16:59:00 EXTERNAL ALARM GENSET STOPPED BY VTDC
    3/30/2012 16:59:00 3/30/2012 17:00:00 EXTERNAL ALARM GENSET STOPPED BY VTDC
    3/30/2012 19:01:00 3/30/2012 19:56:00 EXTERNAL ALARM AC MAINS FAILURE
    3/30/2012 19:02:00 3/30/2012 19:58:00 INTERNAL ALARM MAINS FAILURE
    3/30/2012 22:04:00 3/30/2012 22:52:00 EXTERNAL ALARM AC MAINS FAILURE
    3/30/2012 22:05:00 3/30/2012 22:54:00 INTERNAL ALARM MAINS FAILURE

    Here you will see that there are only four types of alarms on the same date but on different time in a day. i have made a gantt chart for this but the issue is that it make bar different for all alarms. i need only four bars for four alarms.

    Graph is also attached with this.

    Please help.graph.JPG

  2. #2
    Spammer
    Join Date
    01-26-2010
    Location
    Worcester MA
    MS-Off Ver
    Excel 2003
    Posts
    184

    Re: Excel gantt chart for multiple times per day

    You have no choice but to reformat the bars so the multiple bars for each alarm are formatted the same.
    Jon Peltier
    http://PeltierTech.com/

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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