-
Chart is not updating
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
-
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.
-
Chart in not updating
Hi,
Thank you for ur suggestion now its chart is updating.
Regards,
Chandra Shekar
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules