Creating a chart that slopes up based on signup dates

[EdwinX]

Hi guys,

I have a list of hundreds of dates. Each entry represents when someone “signed-up”.

My end result should be a line chart where:
- the horizontal axis is time (months over 3 years)
- the vertical axis is number of sign-ups

So let's say the first part of my data looks like this:
- Feb 8, 2010
- Mar 3, 2010
- Mar 7, 2010
- Mar 20, 2010
- Apr 13, 2010

- So, moving across the chart from left to right, first month (Jan 2010), line is at 0
- Above Feb 2010 tick at bottom the line climbs to 1 (Feb 8)
- Above Mar 2010 tick the line climbs to 4 (3 sign ups for Mar)
- and so on and so on..

I tried formatting the date to by just month and year. I was trying to use a COUNTIF function
=COUNTIF(C2:C125,"Feb 2010")
..but this didn’t work because the data was still in the format 2/8/2010.. and I’d have to write the equation for each month..
There’s got to be a way to automate this..

[Pete_UK]

Does the attached file do what you were looking for?

Hope this helps.

Pete

[jpr73]

Hi,
May be with pivot table and pivot chart
See on attached file a proposal
The cumulated value are in pivot table sum value field > resume the field value by count
Show values > accumulated income by > signed-up
Is that what you expect
Best regards