View Single Post
 
Old 01-21-2012, 01:36 PM
bugserm bugserm is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Jan 2012
Posts: 1
bugserm is on a distinguished road
Default how to display Timestamp on x-axis in Scatter smooth line graph

hi all..
i,m using excel 2010 on windows XP.
i want to display timestamp on the x-axis in the format hh:mm:ss i.e from 17:18:48 hour till 23:59:56 hour instead of just integer i.e 0 to 5000.
i have attached my excel file for reference.
any help would be much appreciated.
Attached Files
File Type: xlsx Temp vs time.xlsx (240.0 KB, 22 views)
Reply With Quote