| Author |
 Topic  |
|
|
mortioli
Average Member
United Kingdom
898 Posts |
 Posted - 12 June 2004 : 06:31:24
|
Hiya
I'm trying to create a graph in Excel (sorry if this is the wrong forum to put this topic in), which shows how many people joined each month.
I'm not a whizz with Excel, but I've used the following formulas to extract the day, month and year of each registration (eg, from the M_DATE field - 20021023191928):
Day
=MID(A2,7,2)
Month
=MID(A2,5,2)
Year
=LEFT(A2,4)
Now I want to count how many joined each month etc, and show the count in a bar graph. Does anyone know how to do this please?
There's probably a much easier way, and something already out there, so if you could let me know either of those instead, that would be great!
Thanks |
Edited by - mortioli on 12 June 2004 06:32:05 |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 12 June 2004 : 07:06:06
|
| There is a MOD somewhere that shows this data straight out of the database. It doesn't graph it, but you get a monthly breakdown that you can graph in Excel in seconds. |
 |
|
|
mortioli
Average Member
United Kingdom
898 Posts |
Posted - 15 June 2004 : 03:08:28
|
| Does anyone know where this is please? |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 15 June 2004 : 06:59:21
|
This mod should do the trick for you.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
mortioli
Average Member
United Kingdom
898 Posts |
Posted - 15 June 2004 : 13:49:23
|
Cheers  |
|
|
|
JPry565
Starting Member
18 Posts |
Posted - 18 June 2004 : 15:21:15
|
Cheers
 |
|
|
|
jensen
New Member
United Kingdom
97 Posts |
Posted - 22 June 2004 : 04:34:01
|
| Thanks, Just what i was looking for |
|
|
| |
Topic |
|
Topic Locked
