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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"sus1e" wrote in message
...
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

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!

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"sus1e" wrote in message
...
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