PDA

View Full Version : Need help on excel graph for the given scenario



mvandhu
01-10-2012, 09:42 AM
Hi All..

I need ur help :help in drawing a graph with the following datas.

The below are the start and end time for a job tat ran for the dates 1st nov 2011, 12 dec 2011, 14 dec 2011

Date JobID Start_Time End_Time
2011-11-01 12345 2011-11-01 23:12:24 2011-11-02 03:01:24
2011-12-12 14567 2011-12-12 12:12:24 2011-12-12 21:53:32
2011-12-14 18673 2011-12-14 17:09:02 2011-12-15 07:24:43

Y AXIS:Time (eg. hh:mm)
X AXIS: Date (only the dates which is mentioned above)

The graph can be a bar or line graph..
:banghead:
Can you please help me by giving me the steps to insert such a graph..: pray2: is t possible:bug:??

mdmackillop
01-10-2012, 02:13 PM
It would be better to attach your data in a workbook.

mvandhu
01-14-2012, 12:38 AM
Hi.. i have attached the workbook

mdmackillop
01-14-2012, 08:26 AM
Try this

mvandhu
01-16-2012, 09:06 AM
Hi...

I have already tried this..
But this is not my case.. I want to indicate both the job's start and end time in the y axis itself. I dont want the run time (End tme - start time) as my Y axis.

mdmackillop
01-16-2012, 12:06 PM
Dates are changed to Text to create X axis labels