Hi,
I have a data set in range A1:D12. I create plots using variouos data from these range: e.q

X Y1 Y2 Y3
Const A1 A4 A7
Const A2 A5 A8

X Y1 Y2 Y3
Const A4 A7 A10
Const A6 A9 A12

and so on

as you can see value in Y2 and Y3 increased by a const no

I use following formula
X Y1 Y2 Y3
Const Indirect("A1") Offset(Indirect("A1"),2,0) Offset(Indirect("A1"),4,0)
Const Offset(Indirect("A1"),0,1) Offset(Indirect("A1"),2,1) Offset(Indirect("A1"),4,1)

as you can see when I have to create next chart I need to change all formulas and offsets (some times)...

Can anybody can suggest optimised method for this....?

Thanks...