LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 58
Default creating a count of dates by quarter

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:


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
filter dates by quarter Larry Excel Worksheet Functions 4 January 9th 08 04:28 PM
count specific weedays remaining in quarter Green Fox Excel Worksheet Functions 4 November 7th 07 07:59 PM
Count of days in a quarter Mahesh Excel Discussion (Misc queries) 6 July 23rd 07 02:53 AM
Quarter Dates LR Excel Worksheet Functions 8 October 31st 06 10:27 AM
Setting quarter dates in excel RGB Excel Discussion (Misc queries) 5 May 15th 06 03:27 PM


All times are GMT +1. The time now is 11:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"