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
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