Partager via


ChartSheetBase.ShowValueFieldButtons Property

Gets or sets whether to display the value field buttons on a PivotChart that is displayed on the ChartSheetBase. This property can be used only in Excel 2010 projects.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Syntax

'Declaration
Public Property ShowValueFieldButtons As Boolean
public bool ShowValueFieldButtons { get; set; }

Property Value

Type: System.Boolean
true to display the value field buttons on the specified PivotChart; otherwise, false.

Exceptions

Exception Condition
MissingMemberException

This property is used in an Excel 2007 project.

Remarks

Set the ShowValueFieldButtons property to true to display the Value field buttons on the specified PivotChart that is displayed on the ChartSheetBase. Set the property to false to hide the button.

The ShowValueFieldButtons property corresponds to the Show Value Field Buttons 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 4. However, this property cannot be used in Excel 2007 projects.

.NET Framework Security

See Also

Reference

ChartSheetBase Class

Microsoft.Office.Tools.Excel Namespace