time graph pivot

Hi,

I need to make a graph based on time and dates. I have about 10 000 rows data. I need to make a grapf that would indicate most frequently recurring times. lets say in frequence of each 10 minutes. pls see the excel file attached

Do the following

1 - insert a header row into A1 type TimeX, B1 Date & C1 Time

2 - insert the following formula

Please Login or Register  to view this content.

3 - create a Pivot Chart using this data as source, configure as follows:

set Time as Row Label and apply Number Format of hh:mm (or Polish equiv.)
set Time as Data Field and set to COUNT rather than SUM

You will not get a data point on the x-axis unless values exist in the source set for that time point.

attached........ 2007 format