Shuvro,

Generally, per Excels help you cant create time-scale charts from data
that is measured in intervals of hours, minutes, or seconds. Only days,
months, and years are considered base units in time-scale charts.

To get around this limitation, assume you have the following time data in
cells A1:A11 and plotted data in cells B1:B11:

Col A is Time Format Data
05/03/2005 23:00 6
05/03/2005 23:15 4
05/03/2005 23:30 5
05/03/2005 23:45 7
05/04/2005 0:00 6
05/04/2005 0:15 5
05/04/2005 0:30 3
05/04/2005 0:45 4
05/04/2005 1:00 5
05/04/2005 1:15 7

Insert a helper column between columns A and B. Add the following text
conversion formula to cell B1 (the new helper column):

=TEXT(A1,"mm dd yy hh:mm")

Copy that formula down the range B1:B11. Finally create your chart using
the range B1:C11.

Col A is Time Format Col B is Text Data
05/03/2005 23:00 05 03 05 23:00 6
05/03/2005 23:15 05/03/05 23:15 4
05/03/2005 23:30 05/03/05 23:30 5
05/03/2005 23:45 05/03/05 23:45 7
05/04/2005 0:00 05/04/05 00:00 6
05/04/2005 0:15 05/04/05 00:15 5
05/04/2005 0:30 05/04/05 00:30 3
05/04/2005 0:45 05/04/05 00:45 4
05/04/2005 1:00 05/04/05 01:00 5
05/04/2005 1:15 05/04/05 01:15 7

The 15 minute difference can be calculated a 1 / 24 / 4, or 0.010417

----------------------------
Regards,
John Mansfield
http://www.pdbook.com


"Shuvro Basu" wrote:

I need help on plotting time in x axis with 15 minute intervals that will
roll over to the next day i.e midnight roll over.

Need this very urgently...