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...
Bookmarks