With charts, a lot depends on the data layout. See the attached file for a chart whose values change when a selection changes in A6. This is done by creating the chart from a single range, but the contents of the range changes with an Index/Match formula.
Is that going towards what you want to do?
Bookmarks