creating a count of dates by quarter

B

Brandon

I am having difficulty building a line chart that shows two lines. One line
represents that number of people enrolled into the program during that
quarter. The other line represents the number of people disenrolled in the
program during the quarter. Below a sample of the table I am working with:

NAME ENROLLMENT MARITAL DISENROLL
John,3/2/2008,S,5/1/2008
Sue,10/3/2007.M,5/4/2008
Tim,11/21/2007,S,3/1/2008
Jane,12/3/2007.M,4/4/2008

I know that the Y axis would be the count of people within the date and the
X axis would be the year and quarter, with the two different lines
representing the count of enrollment and disenrollment.. I can't seem to
figure out how to get the information in the chart.

The help would be greatly appreciated.

Thanks,

:Brandon:
 

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

Top