indirect

[jiwolf]

I am trying to generate a graph based on a set of figures, but i only want
to select the last 12 weeks data.( ie weeks 1 to 12 or week 2 to 13 etc). I
know that the indirect functon will do the trick , but cant get the formula
right.

help please?

 

[Debra Dalgleish]

You could adapt the instructions for a dynamic chart that Jon Peltier
has here:

http://www.peltiertech.com/Excel/Charts/DynamicLast12.html