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
Bookmarks