Dynamic Chart - Changes Defined Name to Range after clicking OK???

1. Dynamic Chart - Changes Defined Name to Range after clicking OK???

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

2. Re: Dynamic Chart - Changes Defined Name to Range after clicking OK???

If you enter the formula into the Chart Data Range it will be converted to range references.

Instead you need to use the Select Data dialog. Add a series and enter the named range reference to the Series Name box.

3. Re: Dynamic Chart - Changes Defined Name to Range after clicking OK???

Thanks, but that was what I was trying to avoid. I want to dynamically create a chart that could increase in the number of data points in a column, but also increase in the number of series as well without having to add each series individually to the charts.

4. Re: Dynamic Chart - Changes Defined Name to Range after clicking OK???

unfortunately it does not work like that.

named ranges are used to alter start and length of a single series

There are currently 1 users browsing this thread. (0 members and 1 guests)