i have this series of data called 'Date&Time', for example:

 

Date&Time

1 nov 2009 19:20

1 nov 2009 19:28

1 nov 2009 19:40

1 nov 2009 20:39

1 nov 2009 20.41

1 nov 2009 21:02

1 nov 2009 21:21

1 nov 2009 22:20

1 nov 2009 22:33

 

 

i've generate a line chart and select a group called Data for "Show value" and Date&Time for "On change of:" and by this selection, the Data group is on the y-axis while DateTime group is on the x-axis. the chart turns out perfectly but the x-axis is showing the time for each data. like:

 

     ,           ,           ,          ,          ,          ,          ,     

 19:20   19:26  19:40  20:39  20:41  21:02  21:21

 

 

so, is it possible for me to change the x-axis format so that it scaled hourly? like this:

 

    ,           ,           ,          ,          ,          ,       ,   

 

thanks in advance...

DBlank,

 

Thank you so much for your reply.

 

is it correct by selecting "for each hour" option is to change the data format? (correct me if im wrong). because what im trying to do is, the data will still be mark according to the data in Date&Time column (19:20, 19:40, 20:39 and so on) but on the x-axis, instead of displaying each of time that is being marked, i need the x-axis display scale by hour.

 

hope u can understand what im trying to do.

 

 

 

thanks for helping me... really really appreciate it... thank you