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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Brooks
    Replies:
    1
    Views:
    561
    Richard Choate
    Jul 16, 2003
  2. Philip Wong
    Replies:
    0
    Views:
    296
    Philip Wong
    Sep 23, 2003
  3. Robert Stober

    How to replace PivotTable data fields...?

    Robert Stober, Oct 5, 2003, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    722
    Robert Stober
    Oct 5, 2003
  4. Frank M.

    Changing link to textfile in Pivottable

    Frank M., Nov 17, 2003, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    293
    Frank M.
    Nov 18, 2003
  5. Guest
    Replies:
    2
    Views:
    544
    Guest
    Jan 8, 2004
  6. fergusor

    Hiding a button when hiding rows

    fergusor, Aug 9, 2006, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    464
    fergusor
    Aug 10, 2006
  7. xpan

    [VBA] Hiding rows in PivotTable

    xpan, Sep 26, 2006, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    246
    Don Guillett
    Sep 26, 2006
  8. Guest
    Replies:
    6
    Views:
    506
    Guest
    Nov 2, 2007
Loading...