+ Reply to Thread
Results 1 to 5 of 5

Pivot Chart - Unable to bring back data once unselected

Hybrid View

  1. #1
    Valued Forum Contributor jj72uk's Avatar
    Join Date
    03-22-2008
    Location
    Essex, England
    MS-Off Ver
    Work - Office 2000, Home - Office 2007E
    Posts
    360

    Pivot Chart - Unable to bring back data once unselected

    Hi all,

    Long time no see, but I need your help once again. Using XL2000 for this.

    I've created a pivot chart which displays multiple different data lines, im having a problem that when i choose just one data to view from the drop down list, when I go back to the drop down to choose a different data all the list with the check boxes have gone.

    Is there anyway in XL 2000 that in my data list i can uncheck and check to my liking?

    Thanks,.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,974

    Re: Pivot Chart - Unable to bring back data once unselected

    No - you have to drag the field from the field list back onto the pivot table.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Valued Forum Contributor jj72uk's Avatar
    Join Date
    03-22-2008
    Location
    Essex, England
    MS-Off Ver
    Work - Office 2000, Home - Office 2007E
    Posts
    360

    Re: Pivot Chart - Unable to bring back data once unselected

    Is there anyway to get around this beside building my own pivot like table with lookups...

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,974

    Re: Pivot Chart - Unable to bring back data once unselected

    You could use code to add/remove the data from the underlying table.

  5. #5
    Valued Forum Contributor jj72uk's Avatar
    Join Date
    03-22-2008
    Location
    Essex, England
    MS-Off Ver
    Work - Office 2000, Home - Office 2007E
    Posts
    360

    Re: Pivot Chart - Unable to bring back data once unselected

    Yeah i was contemplating that... but decided to create some manual dynamic graphs instead.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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