GetValue Method

Microsoft Office Web Components Object Model

Show All

GetValue Method

       

Returns a data value for the specified point in a custom data dimension.

expression.GetValue(Dimension, scaled)

expression   An expression that returns a ChPoint object.

Dimension   Required ChartDimensionsEnum. The dimension from which you are retrieving the value.

ChartDimensionsEnum can be one of these ChartDimensionsEnum constants.
chDimBubbleValues
chDimCategories
chDimCharts
chDimCloseValues
chDimFilter
chDimFormatValues
chDimHighValues
chDimLowValues
chDimOpenValues
chDimRValues
chDimSeriesNames
chDimThetaValues
chDimValues
chDimXValues
chDimYValues

Scaled Optional Variant. Specifies whether to return the actual value of the point, or its percentage as it relates to the other related points. Set this argument to True to return the percentage. This argument is relevant only when you are using a Pie, Doughnut, or Stacked Column chart.

Remarks

Alternatively, you can specify a ChartErrorBarCustomValuesEnum constant for the Dimension argument to return the value of an error bar.
ChartErrorBarCustomValuesEnum can be one of these ChartErrorBarCustomValuesEnum constants.
chErrorBarMinusValues chErrorBarPlusValues