Skip to content

Files

Latest commit

 

History

History
50 lines (28 loc) · 1.2 KB

Excel.Chart.ShowValueFieldButtons.md

File metadata and controls

50 lines (28 loc) · 1.2 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Chart.ShowValueFieldButtons property (Excel)
vbaxl10.chm149192
vbaxl10.chm149192
Excel.Chart.ShowValueFieldButtons
7997b313-ce87-95eb-3d1e-b9b7b6eda84b
04/16/2019
medium

Chart.ShowValueFieldButtons property (Excel)

Returns or sets whether to display the value field buttons on a PivotChart. Read/write.

Syntax

expression.ShowValueFieldButtons

expression A variable that represents a Chart object.

Return value

Boolean

Remarks

Set the ShowValueFieldButtons property to True to display the Value Field buttons on the specified PivotChart. 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, which is available when a PivotChart is selected.

Example

The following code example sets Chart 1 to display value field buttons.

ActiveSheet.ChartObjects("Chart 1").Activate 
ActiveChart.ShowValueFieldButtons = True

[!includeSupport and feedback]