-
Changing default field "All" in pivot table
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
Last edited by lucky245; 07-05-2010 at 11:59 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules