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.

What more than 20 views & no reply.I think i had to think it more deeply regarding the solution.hmmmmmmmmmmm

So.... one more view and a reading tip:

http://www.contextures.com/xlPivot01.html

hth

ok. that s for the link.i hope the same data will create dynamic pivot charts.