Link PivotChart to PivotTable, whilst hiding fields

Discussion in 'Microsoft Excel Programming' started by clifgriffin, Mar 3, 2009.

  1. clifgriffin

    clifgriffin Guest

    My problem is simple:
    I have a pivottable that displays data in several columns based on filters.
    I have a pivotchart based on this pivottable.
    The pivotchart displays ALL data from the pivottable.
    I want to remove one of the value fields that is displayed on the
    PivotChart, but I seem to only be able to do this if I alter the underlying
    PivotTable which is unacceptable.

    I read one guide online that mentioned creating a second PivotTable "based
    on" the first one and using this to create the PivotChart. I've also tried to
    do a dynamic named range but this only resulted in me wanting to kill small
    animals. (I couldn't get it to work at all)

    This seems like it should be a very common problem...any ideas?
     
    clifgriffin, Mar 3, 2009
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Creating a PivotTable Report from an Another PivotTable Report

    Guest, Jan 8, 2004, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    321
    Guest
    Jan 8, 2004
  2. Guest

    PivotTable and PivotChart clear failure

    Guest, Mar 1, 2004, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    260
    BrianB
    Mar 2, 2004
  3. Guest

    Hiding columns whilst autofiltered - PART 2 HELP!!!

    Guest, Oct 8, 2006, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    150
    Tom Ogilvy
    Oct 9, 2006
  4. minimaster
    Replies:
    0
    Views:
    205
    minimaster
    Nov 26, 2007
  5. minimaster
    Replies:
    4
    Views:
    475
    minimaster
    Nov 29, 2007
Loading...

Share This Page