Consulting

Results 1 to 1 of 1

Thread: Changing default field "All" in pivot table

  1. #1
    VBAX Regular
    Joined
    Aug 2006
    Posts
    17
    Location

    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
  •