Dynamic Range For Graph Data

[LenPL]

Hi,
I am trying to set the range for a graph to
=$A$1:$VariableColumn$8

Most of the solutions I have found refer to rows and require ranges for each series.
For my graph the series are fixed, however the columns need expanding.

Thanks in advance,

L

 

[Steve=True]

Hi LenPL,

Most people typically make a dynamic chart range by using the offset formula. Same principles apply in this case study for what you are doing, but instead of the offset formula, you can just manually update your range in the named formula.

case-study-creating-a-dynamic-chart-in-excel-using-offset-formula

Steve=True