Hi everyone,

Here is my problem:

I have database with in column :
-date
-name
-Number of pieces controled

I would like to do Pivotchart which show the number of persons who controled by day (date in abscissa (x-axis) and number of person in ordinate (y-axis).
For instance: Today is 25th of April. Marcel control 20 pieces in morning and Sophie 10. In the afternoon, Marcel control 30 pieces but Sophie is in holidays.
Then I would like Excel return me "2" (two persons controled on 25th Arpil)
Does anybody know what settings have I to do ?

Thanks a lot