Pivot Table updating

[Pjcan1]

I have created a basic pivot chart, with the source data in anothe
worksheet.
How can I get it so that updates to the table are reflected in th
chart automaticall

 

[olasa]

You can't make a Pivottable update everytime something happens (unless
you use some VBA-code).
But you can often make the same 'Pivottable layout' by using formulas.

HTH
Ola