PDA

View Full Version : Changing default field "All" in pivot table



lucky245
07-05-2010, 05:16 AM
I have a pivot table which gets it's data from an autofiltered spreadsheet. The only problem is I use the field names to populate my chart title
The heading "all" is pretty non descript so I would like to change it somehow. Any ideas folks?

I decided to use an if loop for now to capture value and then swap my own value where "All" is captured from the pivot field value