Results 1 to 3 of 3

Thread: Pivot Chart - Hide value filed button on Chart

  1. #1

    Pivot Chart - Hide value filed button on Chart



    Register for a FREE account, and/
    or Log in to avoid these ads!

    How to unhide value filed button on Chart?

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,276
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Sorry, not sure I totally follow on this one. Did you hide the PivotChart Field Buttons? If you're in Excel 2007 or higher, select your PivotChart and go to PivotChart Tools --> Analyze -->Show/Hide. On that group is the "Field List" and "Field Buttons" splitbutton. I'm guessing you just need to uncheck the "Hide All" on the "Field Buttons" splitbutton.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    I'm using Excel 2013 which is, admittedly, newer than your question. But I think it will be the same or similar and really I'm writing this for people who stumble upon this hoping for an answer.

    I found this option on the "PowerChart Tools" "Analyize" ribbon. On the right hand side there is a Field Button menu containing the options you need.

Posting Permissions

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