Charts based on Different Dates

[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

 

[Don Guillett]

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.

 

[Gord Dibben]

See Stephen Bullen's site for a scrollable/zoomable chart.

Download Funchrt7.zip

http://www.oaltd.co.uk/Excel/Default.htm

Copy the chart and you can set the viewing area on each.


Gord Dibben MS Excel MVP