Can I Add Pivot Table Data In To A Text Box

[Paragon_Of_Pain]

Hello!

I have a pivot table and an associated chart, which I have a macro to update the formatting of whenever the table is updated.

What I would also like to add is a text box on the chart to indicate the grand total for columns of each of the two columns fields in the pivot table.

Any help would be hot thanks!
POP