Pivot Chart - Hide value filed button on Chart

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,519
Reaction score
4
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
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.
 

krystofa

New member
Joined
Oct 30, 2014
Messages
1
Reaction score
0
Points
0
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.
 
Top