Forum Discussion
MartinBreeze
Mar 11, 2025Copper Contributor
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.
You cannot use E5. Instead, create named ranges based on E3 and E4 using the OFFSET function. See the attached version.
You cannot use E5. Instead, create named ranges based on E3 and E4 using the OFFSET function. See the attached version.