Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
filter dates by quarter | Excel Worksheet Functions | |||
count specific weedays remaining in quarter | Excel Worksheet Functions | |||
Count of days in a quarter | Excel Discussion (Misc queries) | |||
Quarter Dates | Excel Worksheet Functions | |||
Setting quarter dates in excel | Excel Discussion (Misc queries) |