# X-Y Plot That References an Indirect Range

#### sdruley

##### Well-known Member
 \$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

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
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

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:

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

Replies
3
Views
1K
Replies
0
Views
636
Replies
2
Views
356
Replies
1
Views
1K
Replies
0
Views
490

1,203,236
Messages
6,054,297
Members
444,715
Latest member
GlitchHawk

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back