I am plotting multiple series as a function of one variable. I defined a dynamic range with the defined name of _CurveX in the formulas tab with a reference of OFFSET('Curves X'!$B$3,0,0,180,'Vertex (2)'!$R$3+2). This works fine when I enter this into the Chart Data Range: ='Curves X'!_CurveX, but after I hit OK it removes the 'Curves X'!_CurveX and replaces it with ='Curves X'!$B$3:$L$182 which is not dynamic anymore....
Dynamic Chart.jpg
I basically want to plot the vertices as a function of the angle. But, I have an large number of vertices and I only want the plot a few vertices so I defined a dynamic ranges that depends on an input 'Vertex (2)'!$R$3+2.
Why is it replacing 'Curves X'!_CurveX with 'Curves X'!$B$3:$L$182 after I click ok, and is there a better way of doing this???
Thanks everyone
Bookmarks