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: 20
Default Graph over a time span

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
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
Time Span calculations Jafferi[_2_] Excel Worksheet Functions 4 June 8th 09 05:43 AM
claculating time span Julie Excel Worksheet Functions 1 March 1st 08 01:17 AM
Counting if Something Occurred During a Time Span Daren Excel Worksheet Functions 0 September 20th 07 07:06 PM
Dividing a time span into shifts - overlapping days Heidi Excel Worksheet Functions 17 February 28th 06 01:40 AM
Time Span mrbalaje Excel Discussion (Misc queries) 6 June 16th 05 11:34 PM


All times are GMT +1. The time now is 03:22 PM.

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"