I'm seeking your help on creating a dynamic range for my Excel 2010 chart (attached).
In the yellow cell (B2), is an integer user field. I have tried to link this to an offset formula that calculated a charts x & y axis (see green cells).
I would like the charts range to update whenever a user edits B2. I tried creating a named reference for the chart series, but it didn't work.
Can you tell me what I'm doing wrong?