Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2007
    Posts
    127

    Unanswered: Pivot Charts - Removal of Series Field box

    In a normal Pivot Chart Layout theres is a box called "Drop Series Fields Here".

    How do I remove it, I know that it doesn't get printed but I dont want it to be displayed.

    Thanks in advance

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. Can you post a sample? I'm having trouble visualizing it.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Oct 2007
    Posts
    127
    hope this help mate


  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    Another option would be to use formulas from the Pivot Table, then create a chart from that, not on a chart sheet, but a normal worksheet. Or use VBA and create the Pivot and the chart entirely in VBA.

    [Edited in light of next post]
    Last edited by shades; 11-01-07 at 11:12.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  5. #5
    Join Date
    Oct 2003
    Posts
    1,091
    Oops, I stand corrected. Simple really:

    With the pivot chart selected, on the pivot toolbar, choose PivotChart>Hide PivotChart Field buttons.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  6. #6
    Join Date
    Oct 2007
    Posts
    127
    thanks mate

Posting Permissions

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