Question related to create dynamic chart in multiple worksheets with the help of VBA code

Hello Everyone, 

My aim is to make a chart, which takes a dynamic range and updates and iterates through the sheet with the help of VBA code.

So, what should i write in VBA code?

Please help

Here is a attached file...