XL: Charting implicit values? Tough! 1

[VBAjedi]

I have a list of contract numbers in column A, with their start and end dates in columns B and C. Example:

123 1/23/03 3/03/03
225 1/29/03 5/17/03
413 1/12/03 7/01/03
etc. . .

I'd like to create an area chart that shows how many contracts are active from week to week. Any ideas?

Thanks!

VBAjedi

 

[SkipVought]

Use the wizard to chart ALL the date.

Use AutoFilter to select the data you want to see on your chart.

VOLA! Skip,
Skip@theofficeexperts.com

 

[SkipVought]

Sorry, I answered too soon. You have a much more complex problem here -- I am working on it! Skip,
Skip@theofficeexperts.com

 

[VBAjedi]

Skip,

ComplexProblems-R-Us, at your service!



I am frankly a bit surprised that Excel doesn't make this easier - it would be a very useful function to be able to chart items with an associated date range in that way.

VBAjedi

 

[SkipVought]

I have an example for you. Send me your eMail address and I'll shoot it your way Skip,
Skip@theofficeexperts.com

 

[SkipVought]

I NEED TO GIVE CREDIT TO DALE WATSON FOR HIS HELP WITH DCOUNTA.


THANKS DALE! Skip,
Skip@theofficeexperts.com

 

[VBAjedi]

Skip,

That would be much appreciated! You can email me that sample file at ldeese@obie.com

Thanks for your help.

VBAjedi

 

[mrtweaks]

so no one else will know what it was go on share it

 

[SkipVought]

Well tweaky,
It is in a workbook with several formulas and a chart, so its kinda hard to explain all that in a text browser. :-( Skip,
Skip@theofficeexperts.com