Excel Dynamic Graph Series
Posted on 2011-02-12
I have an Excel Workbook with numerous graphs. An example of a graph series is below:
=SERIES("Gross Revenue with Fed Taxes",'2 Yr Rev with Taxes'!$C$67:$Z$67,'2 Yr Rev with Taxes'!$C$78:$O$78,1)
the $C$78:$O$78 above is the range for the graph where $O$78 is the end of the graph line for January and will need to be changed to $P$78 for February , and so on. I have been making this change manually and would greatly appreciate a way to have the reference automatically change based on a month number that is entered on a control sheet. Thanks in advance for any assistance.