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

Temp vs time.xlsx (240.0 KB, 20 views)

Hi
your time values in col B are text looking like time, not real times.
To solve, in an unused column, insert =timevalue(B5) and drag down to the end of the range.
Copy then Paste Special Values over col B - Format as needed

Then rebuild your graph

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post