Chart is not updating

[Chandrasheka]

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

[mbarron]

Either add a column header to your A column or change chtCats to:
=OFFSET(Sheet1!$A$1,COUNTA(Sheet1!$A:$A),0,-MIN(chtLen,COUNTA(Sheet1!$A:$A)),1)

While determining what range to use, chtCat is subtracting 1 from the count of cells with data in the A column - it assumes there is a column header associated with the data.

[Chandrasheka]

Hi,

Thank you for ur suggestion now its chart is updating.

Regards,

Chandra Shekar