Create a chart of totals over time?

N

Nellie Nobody

I have a worksheet containing a User Type column and a Date/Time column. The
User Type is a code between 0 and 9. The Date/Time is formatted as mm-dd-yyyy
hh:mmAM/PM. Example:

USER TYPE DATE/TIME
0 12-07-2009 11:09AM
0 12-07-2009 11:09AM
2 12-07-2009 11:09AM
1 12-07-2009 11:09AM
9 12-08-2009 1:19PM
2 12-08-2009 1:19PM
2 12-08-2009 1:19PM
0 12-09-2009 11:52AM
1 12-09-2009 11:52AM
9 12-09-2009 11:52AM

As you can see, User Types can occur multiple times for each Date/Time value.

I need to create a chart of the total number of type 0 and type 9 users over
time. Should I create a new worksheet with formulas then create the chart
from that worksheet? If so, what formula should I use?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count based on date criteria 1
counting the number of consecutive days 12-17-09 2
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Pivot Table showing wrong data 1
help with datedif function please 5
How do I find a match for three variables to determine the result? 2
SUMIF or COUNTIF 1
IF ARRAY with multiple conditions. 1

Top