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?

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

http://www.peltiertech.com/Excel/Cha...micLast12.html

jiwolf wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html