Chandrasheka
09-29-2010, 02:41 AM
Hi,
I could not able to update my chart. I referring site http://peltiertech.com/Excel/Charts/DynamicLast12.html and I am using names as given below
chtCats
=OFFSET(Sheet1!$A$1,COUNTA(Sheet1!$A:$A)-1,0,-MIN(chtLen,COUNTA(Sheet1!$A:$A)-1),1)
chtLen
=Sheet1!$D$2
chtValA
=OFFSET(chtCats,0,1)
chtValB
=OFFSET(chtCats,0,2)
I am attaching excel file please let me know where the error is here I should get the chart for the month Mar-08 - Feb-09.
Thanks
I could not able to update my chart. I referring site http://peltiertech.com/Excel/Charts/DynamicLast12.html and I am using names as given below
chtCats
=OFFSET(Sheet1!$A$1,COUNTA(Sheet1!$A:$A)-1,0,-MIN(chtLen,COUNTA(Sheet1!$A:$A)-1),1)
chtLen
=Sheet1!$D$2
chtValA
=OFFSET(chtCats,0,1)
chtValB
=OFFSET(chtCats,0,2)
I am attaching excel file please let me know where the error is here I should get the chart for the month Mar-08 - Feb-09.
Thanks