Link PivotChart to PivotTable, whilst hiding fields

Discussion in 'Microsoft Excel Misc' 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. Philip Wong
    Replies:
    0
    Views:
    170
    Philip Wong
    Sep 23, 2003
  2. Frank M.

    Changing link to textfile in Pivottable

    Frank M., Nov 17, 2003, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    214
    Frank M.
    Nov 18, 2003
  3. Guest
    Replies:
    2
    Views:
    315
    Guest
    Jan 8, 2004
  4. xpan

    [VBA] Hiding rows in PivotTable

    xpan, Sep 26, 2006, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    151
    Don Guillett
    Sep 26, 2006
  5. Guest
    Replies:
    6
    Views:
    276
    Guest
    Nov 2, 2007
Loading...

Share This Page