+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Pivot Table -- Hide Fields instead of Remove Fields?

  1. #1
    Registered User
    Join Date
    10-05-2004
    Posts
    4

    Pivot Table -- Hide Fields instead of Remove Fields?

    I have a pivot table and a pivot chart setup. I want to chart each column in the pivot table 1, column at a time. If I uncheck the fields that I don't want in the chart, it takes them out of the value table, like I want it too. When I recheck to show that column, the options that I had set in the Value Field Settings are lost. Instead of removing/adding fields like this is there a way to hide/show fields or some other way to retain the settings for that field?

  2. #2
    Registered User
    Join Date
    10-05-2004
    Posts
    4

    Re: Pivot Table -- Hide Fields instead of Remove Fields?

    Solved: Need to consolidate ranges.

    http://www.contextures.com/xlPivot08.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1