X-Y Plot That References an Indirect Range

[sdruley]

$TC$2:$WX$3

<tbody>
</tbody>

is an indirect range that resides in cell B15. It is constantly changing and the expectation is that the X_Y plot would adjust accordingly. It represents the data range of the chart. The chart does not carry with it any title.
So how do I approach this without using vba? As always any input is highly valued.

Steve

 

[Steve=True]

Hi Steve,

Can you do this like you would with an offset chart?

Create a named formula that references your range.

then add it to a chart series like in this post:[h=2]How-to Make a Dynamic Chart Using Offset Formula[/h]No VBA required.

Let me know if it helps!

Steve=True

 

[sdruley]

Hey Steve,

I believe I figured out how to do this. The data for the chart is represented by the cell D16 and now reads as follows CRYSTAL!$TC$2:$WX$3
The formula to get this expression is as follows: ="CRYSTAL!"&OFFSET(INDEX(PEARSONarray,PEARSONindex),3,0)
When creating a new chart I entered (with no equal sign) INDIRECT(CRYSTAL!D16) into the "Chart Data Range"
Then as I go through my program I update the chart by triggering the following code:

    Sub UpdateChainAlignment()    ActiveSheet.ChartObjects("Chart 2").Activate
    ActiveChart.PlotArea.Select
    ActiveChart.SetSourceData Source:=Range("INDIRECT(CRYSTAL!D16)")
    End Sub

I guess I answered my own question.

Steve