Dynamic Pivot Chart based on Pivot Table.

I had a sheet with columns:
S.No Tran ID Value Date Description Cr/Dr Dr.Amt Cr.Amt & Bal.
I want to build Pivot Chart based on a pivot table with this data. the data for this columns keep Adding every day.how would i design a dynamic chart with dynamic pivot table in the same sheet.
I m attaching the data file.