Automatic Graph generation by series

[SiliconAlleyDude]

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?

 

[John Mansfield]

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

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=518

 

[SiliconAlleyDude]

John,

Thanks for this reply. I will try to implement this into my workbook.

SiliconAlleyDude