I know this has been asked before but I've read the responses and I just can't seem to get it to work.
I have the following data:
Y Values: C7:C57
X Values: B7:B57
However, I need the user to be able to set the number of rows that are charted. For example, if the user typed in B1 that they wanted to chart 5 rows of data then I would want the chart reference to dynamically change to:
Y Values: C7:C11
X Values: B7:B11
I've googled it and it looks like I need to name ranges and use an indirect and/or an offset formula, but my Data Source chart dialogue box will not allow either to be entered into the Y Values or the Category (X) Axis Labels cells.
How can I pull this off?
I have the following data:
Y Values: C7:C57
X Values: B7:B57
However, I need the user to be able to set the number of rows that are charted. For example, if the user typed in B1 that they wanted to chart 5 rows of data then I would want the chart reference to dynamically change to:
Y Values: C7:C11
X Values: B7:B11
I've googled it and it looks like I need to name ranges and use an indirect and/or an offset formula, but my Data Source chart dialogue box will not allow either to be entered into the Y Values or the Category (X) Axis Labels cells.
How can I pull this off?