graph range varying depending on dates

[Guest]

I am new to programming. I need to create a graph with a data source range
which will vary depending on the date. For example,

I have a table which contains all the weeks of the year and need to graph on
a rolling 13 week period. i.e. If we are in week 14 I need the graph to show
the data for weeks 2-14, if we are in week 15 I need the graph to show the
data for weeks 3-15. I would like the user to be able to specify the current
week. The graph would be preformatted and will just need to be updated. (I am
using Excel 2003)

Any ideas?

Thanks
Susie

 

[Jon Peltier]

This example dynamically plots the last 12 months. I'm sure you can make the
needed changes.

http://peltiertech.com/Excel/Charts/DynamicLast12.html

- Jon

 

[Guest]

I actually found your website by accident (the wonders of search engines!)
and have managed to work it out from there.

Thank you for all your help and your wonderful site!