Yes, you can do so by creating dynamic formulas to control the series. You
can find an explanation here.

http://pubs.logicalexpressions.com/P...cle.asp?ID=518

----
Regards,
John Mansfield
http://www.pdbook.com

"SiliconAlleyDude" wrote:

In my work book I have a sheet which contains Scheduled installations and
successful installations per week.

Is there a way to automatically generate a graph depending on the week number?

--
SiliconAlleyDude