SOLVED

Excel graph with time stamp

%3CLINGO-SUB%20id%3D%22lingo-sub-1423010%22%20slang%3D%22en-US%22%3EExcel%20graph%20with%20time%20stamp%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423010%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20colleagues%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20struggling%20with%20the%20graph%20functions%20in%20Excel.%3C%2FP%3E%3CP%3EI%20have%20a%20set%20of%20data%20%5Btime%2Ctemperature%5D.%20My%20time%20value%20starts%20from%2000%3A28%3A28%20and%20ends%2000%3A05%3A00%20(so%20about%2037minutes).%20I%20have%20troubles%20with%20expressing%20such%20set%20of%20data%20as%20my%20data%20turns%20to%2000%3A00%3A00%20after%20passing%2000%3A59%3A59.%20However%2C%20I%20get%20a%20fine%20graph%20when%20I%20choose%20the%20time%20function%20h%3Amin%3Asec.%20where%20it%20misunderstand%20my%20data%20to%20be%2028%3A28%3A00%20insted%20of%2000%3A28%3A28.%20(Please%20check%20attached%20file)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%20of%20how%20to%20express%20my%20data%20to%20start%20in%2000%3A00%3A00%20and%20end%20in%20about%2037%3A00%3A00%2C%20given%20by%20every%20five%20minutes%20on%20the%20x-axis%3F%20Any%20help%20is%20really%20appreciated!%20Thanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1423010%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423112%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20graph%20with%20time%20stamp%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423112%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F681935%22%20target%3D%22_blank%22%3E%40Hafnia%3C%2FA%3E%26nbsp%3BInserted%20some%20helper%20calculations%20from%20F127%20downwards.%20Then%2C%20formated%20the%20horizontal%20axis%20with%26nbsp%3B%3CSPAN%3Ea%20label%20interval%20of%20300%20(%3D5%20min%20of%2060%20seconds%20each).%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ESee%20attached.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423144%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20graph%20with%20time%20stamp%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423144%22%20slang%3D%22en-US%22%3EThanks!%20Really%20appreciated!%3C%2FLINGO-BODY%3E
New Contributor

Dear colleagues,

 

I'm struggling with the graph functions in Excel.

I have a set of data [time,temperature]. My time value starts from 00:28:28 and ends 00:05:00 (so about 37minutes). I have troubles with expressing such set of data as my data turns to 00:00:00 after passing 00:59:59. However, I get a fine graph when I choose the time function h:min:sec. where it misunderstand my data to be 28:28:00 insted of 00:28:28. (Please check attached file)

 

Any idea of how to express my data to start in 00:00:00 and end in about 37:00:00, given by every five minutes on the x-axis? Any help is really appreciated! Thanks in advance!

2 Replies
best response confirmed by Hafnia (New Contributor)
Solution

@Hafnia Inserted some helper calculations from F127 downwards. Then, formated the horizontal axis with a label interval of 300 (=5 min of 60 seconds each).

 

See attached.

 

Thanks! Really appreciated!