Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Plot time scale in Excel
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... |
#2
|
|||
|
|||
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... |
#4
|
|||
|
|||
Ideally, you should have date-and-time information on the x-axis. Since
your data are equally spaced along the x-axis, you can create any kind of chart. For anything other than a XY Scatter chart, just ensure that the x-axis type is set to 'category' (select the chart then Chart | Chart Options... | Axes tab). -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article , "=?Utf- 8?B?U2h1dnJvIEJhc3U=?=" <Shuvro says... 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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Everytime I need to format cells or text, Excel 2003 takes a lot of time or free | Excel Discussion (Misc queries) | |||
Excel sheet for workout jogging time and graph | New Users to Excel | |||
Can you plot individual numbers on a bell curve in excel, and how. | Excel Discussion (Misc queries) | |||
in excel totaling weekly hours military time | Excel Worksheet Functions | |||
how can i add time in excel? | Excel Worksheet Functions |