-1

When I was searching, I recognized a previous post: Change the Point Color in chart excel VBA. It was said we can get the value of a point in a chart by using this: .Points(PointNumber).Value. Does point have value property? Thanks for your time and help.

Community
  • 1
  • 1
Han JIAO
  • 3
  • 1
  • 3

1 Answers1

0

No, see http://msdn.microsoft.com/en-us/library/office/aa174283(v=office.11).aspx?query=point+object+vba

What you want is the values or xvalues of the series, see http://msdn.microsoft.com/en-us/library/office/ff840677(v=office.15).aspx

Dale M
  • 2,453
  • 1
  • 13
  • 21