Charts based on Different Dates

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

Hi,

Can anyone tell me how to (if possible) create a series of charts that
involve certain dates throughout the year. The data will be the same
for all charts but I want it to be between dates. I might want to see
charts for 01/01/10 to 31/03/10 or I might want to see the same Charts
but for different dates like 01/04/10 to 30/06/10 or from 01/01/10 to
30/06/10

Is it possible to be able to enter the "from" date into say A1 and the
"to" date into B1 and then the charts will automatically show the
corresponding data. I have something fixed already using sumproduct
formula combined with month(Range)=from date etc.

Hope this makes sense.

Regards

Peter
 
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
 
Back
Top