Create a dynamic chart with dynamic range

[nando88]

I want to create a scattered plot graph with data that will change depending on a selection of a list.
I already have the dynamic range in a cell, but I can't seem to use the indirect function in the graph, in order to make the data in the graph change.
Can someone please tell me how to make this work?

 

[oldbrewer]

surely, the graph is driven by the data if 3,4,5 changes to 4,4,5,5,6,6,7,7, your chart will reflect this ?

 

[nando88]

The thing is that when I change the range, I make it so that it shows less information than when the graph was originally created, and the graph doesn't reflect the changes. I change from AM1:AN5 to AM1:AO5, but the graph doesn't reflect the changes.
What can I do?

 

[oldbrewer]

units

week1

12

values

=dynamic4.xls!chval

week2

22

cat x labels

=dynamic4.xls!chlab

week3

25

week4

18

week5

16

chval

=OFFSET(Sheet1!$B$1,1,0,COUNTA(Sheet1!$B:$B)-1,1)

week6

chlab

=OFFSET(chval,0,-1)

the chart now has 5 bars

if you add data for week6 and week7 it will have 7 bars

if you delete week 4 data and onwards it will have 3 bars

with no empty spaces on the chart

this is copied from a fully working dynamic chart

barbara dalgleish website good for dynamic ranges

jon peltier website may help also

<colgroup><col width="64" span="14" style="width:48pt"> </colgroup><tbody>
</tbody>