I need to create a dynamic pivot chart whose title changes as the pivot table is changed.
I mention Excel Web Access in the title as some of the solutions I have read about include adding text boxes which are not acceptable on Excel Web Access and Sharepoint.
I know nothing of VBA, so I was hoping for an answer which does not involve using it.
Is that possible?
Bookmarks