title: Excel VBA Chart Not Recognizing Values
body: <p>I have another pretty perplexing problem that one of you might be able to solve. So basically I have this code to write a line graph using Excel VBA. It's made so it can be dynamic and can change if more values are added. But it's reading the first value as 0 and the last value as 0 even though they are not 0. Here is the code I'm using to put the graph on the page.</p>
  
  <pre><code>Sub createchart4()
  
  lastA = Range("A1").End(xlDown).Row
  ActiveSheet.Shapes.AddChart.Select
  ActiveChart.ChartType = xlLine
  ActiveChart.SetSourceData Source:=Range("Main!$A$1:$A$" &amp; lastA)
  ActiveChart.ChartTitle.Select
  ActiveChart.SeriesCollection(1).Name = "=Main!$A$1"
  ActiveChart.SeriesCollection(1).Values = "=Main!$A$3:$A$" &amp; lastA
  
  End Sub
  </code></pre>
  
  <p>It's saying that A3's value is 0 when it's actually 1534 and it's also reading A10 and A11 as 0 also when they're different as well.</p>
  
  <p>If you can figure this out, I would be amazed :D</p>