Forum Discussion

MartinBreeze's avatar
MartinBreeze
Copper Contributor
Mar 11, 2025
Solved

chart / data range to variable ??

Hello, 

I draw a chart with specific data range C11:C20 like below.

but I want to change data range of chart dynamically.

I made data range text in cell E5 and it is B10:B100.

How can I make E5 text as data range text of chart ? is it possible?

I'd like to redraw chart dynamically when I change E5 cell text.

 

 

Resources