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
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