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 for example from 17:18:48 hour till 23:59:56 hour instead of just integer i.e 0 to 5000.
any help would be much appreciated.

Hello,

To do this, i would do the following:

If your first time was in A1 and your second time was in B1

Then in Cell C1 I would type in this fomula

=TEXT(A1,"hh:mm:ss")&" to "&TEXT(B1,"hh:mm:ss")

Then create your chart.

Add a chart Horizontal Axis title.

Then click on the Horizontal Axis title.

Then type in the equals sign (=)

Then Select cell C1

Let me know if this help.

Steve=True