ChartSheet.ShowAllFieldButtons Property
Gets or sets whether to display all field buttons on a PivotChart that is displayed on the ChartSheet.
Namespace: Microsoft.Office.Tools.Excel
Assemblies: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
Property ShowAllFieldButtons As Boolean
bool ShowAllFieldButtons { get; set; }
Property Value
Type: System.Boolean
true to display all field buttons on the specified PivotChart; otherwise, false.
Exceptions
| Exception | Condition |
|---|---|
| MissingMemberException | This property is used in an Excel 2007 project. |
Remarks
Set the ShowAllFieldButtons property to true to display all field buttons on the specified PivotChart that is displayed on the ChartSheet. Set the property to false to hide all field buttons.
The ShowAllFieldButtons property corresponds to the Hide All command on the Field Buttons drop-down list of the Analyze tab in Excel, which is available when a PivotChart is selected.
Note
This property appears in IntelliSense in Excel 2007 projects that target the .NET Framework 4However, this property cannot be used in Excel 2007 projects.
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.