Automatic Graph generation by series
 

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

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

John,

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

SiliconAlleyDude

"John Mansfield" wrote:

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