How to draw a conditional graph in excel using vba?

Hello!

I need a help to draw a conditional graph in excel using vba.

Excel Worksheet1: Statement Tool,
SheetName: Merchant: Creating a tool. In this I am entering the TID No and taking data from 3 different sheets based on the TID No and final calculation is showing on this.

Excel Worksheet2: Net Earnings Log
SheetName: Net Earnings : Displayed with TID No and Monthly earnings as in the sheet.

I have completed till the calculation part.

Now I want as per the TID No. the last 12 months data should be selected and the graph should display on sheet Merchant.

Kindly help on this.

Thanks a lot in advance.