Dynamic Chart with Auto resize

hi Sri. create dynamic range for each series first.

1. press CTRL + F3 to open the Name Manager window.
2. Click on New.
3. Input a Name. i named mine RangeA.
4. in Refers to, input this formula
=$B$2:INDEX($B$2:$N$2,COUNTA($B$2:$N$2))
5. Press OK.

Do the same steps for BB, but change steps 3 and 4 to this:
3. i named it RangeB
4. formula is:
=$B$3:INDEX($B$3:$N$3,COUNTA($B$3:$N$3))

1. Now right-click the chart and choose Select Data. if it's not available in Excel 2016, try something similar.
2. Click on Edit for AA.
3. inside Series values, input this (remember to input worksheet name):
=Sheet1!RangeA

Repeat for BB, but differ in steps 2 and 3.
2. Click on Edit for BB
3. input:
=Sheet1!RangeB

you may use this as reference:
http://www.techrepublic.com/blog/mic...arts-in-excel/