Hi world,

This is my log (20k) <http://img2.freeimagehosting.net/uploads/
32373110dd.png>

I have been trying to adapt a dynamic chart tutorial from Jon Peltier
into a Excel filetransfer log. Dates along the x-axis and the sum of
files transferred per day along the y-axis. Only problem is that I
cant figure out how to plot the sum of total files transferred pr.
date.

In my log I have multiple entries for the day 23-11-2007, but instead
of a total file count for the whole day Excel only use the last entry
(A16).

This is my named ranges:

AllDates:
<=Data!$A$1:INDEX(Data!$A:$A;MATCH(9,99999E+307;Data!$A:$A))>
ChartDates:
<=OFFSET(AllDates;MATCH(StartDate;AllDates;
1)-1;0;MATCH(EndDate;AllDates;1)-MATCH(StartDate;AllDates;1)+1;1)>
FileCount:
<=OFFSET(ChartDates;0;5)

I have had very competent help from this group before constructing a
sumproduct function for the log. Having the chart plot total file
count pr. date is the last hurdle. I have tried inserting a COUNTA
function from another Peltier tutorial but this didn't do anything. I
assume one of my ranges requires a little bit of tweaking. Anyone?

Best regards,
Rasmus