how to create a chart that reflects repetition?

**wasnas** · 03-17-2009, 07:34 AM

Hi,

I have a databse of clients' registration dates.
I would like to create a chart that displays the registration trend, so I can measure it with the effects of activities.
Now, each line has the customer's name, country and registration date.
So the date column goes something like:

01/01/2008
02/01/2008
02/01/2008
02/01/2008
03/01/2008
03/01/2008

How I can make a chart that will display on the X acces the date and on the Y access the number of repetitions: so I get basically 1 for 01/01/2008, 3 on 02/01/2008 etc?

**ChrisNor** · 03-17-2009, 08:05 AM

I would make a column with only unique dates, and then a formula in column B which counts the occurances for that data.

=COUNTIF(A1:A100;B1)

A1:A100 should be the range with all your dates:

01/01/2008
02/01/2008
02/01/2008
02/01/2008
03/01/2008
03/01/2008

B1 should be the date you want to count for.

**shg** · 03-17-2009, 08:47 AM

Welcome to the forum.

The FREQUENCY function does exactly what you wish. See Help and post back if need assistance in implementing-- and if so, please post an example workbook.

**wasnas** · 03-17-2009, 10:06 AM

Thanks for all the help.
At the end, I figured out I will not currently use this function, since I need to measure for now by month, not by date.
But thanks anyway. It is for sure something I am going to use later on.