Graphing Dynamic Arrays

**ih8xc** · 03-10-2011, 08:22 PM

I am trying to graph some data using a dynamic array. The array updates in size properly but the graph doesn't update with the array.

When I "select data" I type in:

Please Login or Register  to view this content.

I then click ok, and the graph forms exactly how I want it. When I go back in the "select data" area the equation now shows the exact cell references as opposed to the dynamic array name.

Is there any way to work around this and have the graph maintain the array name?

Thanks in advance.

**shg** · 03-10-2011, 08:53 PM

How is the range name defined?

**ih8xc** · 03-10-2011, 08:59 PM

=OFFSET($R$1,0,0,13,$Q$1)

Where Q1 is a cell that counts the number of columns that are not #N/A errors.

**ih8xc** · 03-11-2011, 03:44 PM

Still having trouble with this. I've searched the forum here and elsewhere online but can't find a solution.

**ChemistB** · 03-11-2011, 05:21 PM

I believe that the dynamic range needs to be within the same workbook, otherwise it converts it to a static range. Sorry.

**ih8xc** · 03-11-2011, 05:28 PM

Originally Posted by ChemistB

I believe that the dynamic range needs to be within the same workbook, otherwise it converts it to a static range. Sorry.

It actually is within the same workbook. I only used the workbook reference because that's how it appeared on other graphs. It also wouldn't accept "=Months_fish"

**Andy Pope** · 03-12-2011, 07:37 AM

If you enter the source data as a named reference the chart will revert to static range reference once the chart is built.

You need to define the named range parts for the values and category sections of each data series.