Auto update Pivot Chart

Hi,

Apologies if this has been answered but my searches don't seem to resolve my question.

I have created a Dashboard that I want to use as a template.

Daily transaction data will be appended to the data tab and I want to make sure that the pivot table and chart update automatically. Is there a way to do this?

See attached file.

Thanks