I have created a basic pivot chart, with the source data in another worksheet.
How can I get it so that updates to the table are reflected in the chart automatically
I have created a basic pivot chart, with the source data in another worksheet.
How can I get it so that updates to the table are reflected in the chart automatically
Last edited by Pjcan1; 06-14-2005 at 11:16 AM.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks