0

I need to return the value of a data point in a chart to compare it to a known value and display a data label if it is over a certain threshold in PowerPoint.

This post explains how to do it in excel, but .values doesn't appear to be in the ppt object model.

Determining the value of a point in Excel VBA

I know there is .points(i), but that doesn't seem to be able to return the actual value of the point.

Any help is appreciated.

Thanks, Brian

Community
  • 1
  • 1
Brian Hannah
  • 1

1 Answers1

0

This seems to work fine for me

Dim chartSeries As Series
Set chartSeries = chartShape.Chart.SeriesCollection(1)
seriesValue = chartSeries.Values(1)
Paul B.
  • 2,394
  • 27
  • 47