title: Determining the value of a point in Excel VBA
body: <p>I am trying to have the points in a chart change color if they are within certain value paramaters (i.e., >1 is green, &lt;1 is red, anything else is blue).  I cannot determine how to get VBA to give me the value of any given point.</p>
  
  <p>In <a href="https://stackoverflow.com/questions/11136194/change-the-point-color-in-chart-excel-vba">this thread</a>, previously answered, the answer (very helpful in other ways) indicates that points(num).value will return the value at the point. However, I am getting an error message doing this, and nowhere else online or in the VBA help can I find a method that corresponds to this.  Has anyone else had any success with this?</p>
  
  <p>Here's the snippet of code giving me trouble: </p>
  
  <pre><code>For Count = 1 To 7
      If Worksheets("Sheet1").ChartObjects("ChartName").Chart.SeriesCollection(1).Points(Count).Value &gt; 1 Then
      '... do stuff
  </code></pre>
  
  <p>Because of the way the data are stored in the dataset, it would definitely be better to get the value from the chart directly.  I could figure out a workaround using the dataset itself, but I would rather avoid that.</p>