Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi, can anyone please help?
Is there a way to graph from a span of time. We have Members with certain benefits that is good forever basically and then Members by their Contract St and End Dt and Members in special programs. So the data looks like for example: Member StDt EndDt ContractFees Contract Type Member A 1/1/2006 12/31/2009 $500 Program C Member B 1/1/2006 doesn't expire $2000 Program A Member C 6/1/2006 5/1/2010 $1000 Program B So I'd like to be able to count the # of members over time from Jan 2006, then June 2006 ... April 2010 So January 2006 would show 2 members and June 2006 would show 3 members April 2010 would show 2 members etc... -- Thank you in advance!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time Span calculations | Excel Worksheet Functions | |||
claculating time span | Excel Worksheet Functions | |||
Counting if Something Occurred During a Time Span | Excel Worksheet Functions | |||
Dividing a time span into shifts - overlapping days | Excel Worksheet Functions | |||
Time Span | Excel Discussion (Misc queries) |