Pivot Table Auto Referesh

Hi,

I have a pivot table on the "customer" sheet which I need to automatically refresh if the user changes any of the data (this is restricted to columns C and F)

i have tried 3 different codes that i have found online but neither have worked (these are contained in the attached file)

does anyone have a code that refresh the table, rather than me having to right click the table and then hitting refresh?

I would only want it to auto refersh the pivot table on this "customer" sheet.

It is the blue graph I have the problem with