Display/Show related procedures in class Chart (PowerPoint VBA)

This page presents procedures from class Chart related to the theme Display/Show: DisplayBlanksAs, ShowAllFieldButtons, ShowDataLabelsOverMaximum and ShowLegendFieldButtons

DisplayBlanksAs

Returns or sets the way that blank cells are plotted on a chart. Can be one of the XlDisplayBlanksAs constants.

Possible Values are xlInterpolated - Values are interpolated into the chart, xlNotPlotted - Blank cells are not plotted, xlZero - Blanks are plotted as zero.
ActivePresentation.Slides(1).Shapes(1).Chart.DisplayBlanksAs = xlInterpolated

ShowAllFieldButtons

Returns or sets a value that indicates whether to display all field buttons on a PivotChart.

This member is part of the shared chart object model infrastructure between Word, Excel, and PowerPoint and is not meant to be called directly from your code. Reading or setting this property causes a run-time error. In PowerPoint, you cannot create a PivotChart, and copying or pasting a valid PivotChart from Excel to a PowerPoint presentation will convert the PivotChart to a Chart.

ActiveWindow.RangeFromPoint.Chart.ShowAllFieldButtons = True

ShowDataLabelsOverMaximum

Returns or sets a value that indicates whether to show the data labels when the value is greater than the maximum value on the value axis.

If you change the value axis in such a way that it becomes smaller than the size of the data points, you can use this property to set a value that indicates whether to show the data labels. This property applies to 2D charts only.

ActiveWindow.RangeFromPoint.Chart.ShowDataLabelsOverMaximum = True

ShowLegendFieldButtons

Returns or sets a value that indicates whether to display legend field buttons on a PivotChart.

This member is part of the shared chart object model infrastructure between Word, Excel, and PowerPoint and is not meant to be called directly from your code. Reading or setting this property causes a run-time error. In PowerPoint, you cannot create a PivotChart, and copying or pasting a valid PivotChart from Excel to a PowerPoint presentation will convert the PivotChart to a Chart.

ActiveWindow.RangeFromPoint.Chart.ShowLegendFieldButtons = True