Forum Discussion
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 t...
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.
