title: Using VBA Excel to create Scatter Plot
body: <p>This is my VBA code to create a scatter plot in Excel:</p>
  
  <pre><code>Sub createmychart()
      Dim Chart1 As Chart
      Set Chart1 = Charts.Add
      With Chart1
          .SetSourceData Source:=Sheets("usd_download data").Range("A2:B26001")
          .ChartType = xlXYScatter
      End With
  End Sub
  </code></pre>
  
  <p>However, it ended up like this:</p>
  
  <p><a href="https://i.stack.imgur.com/q8Tn9.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/q8Tn9.jpg" alt="enter image description here"></a></p>
  
  <p>But I would like to have a graph like this:</p>
  
  <p><a href="https://i.stack.imgur.com/K3yKY.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/K3yKY.jpg" alt="enter image description here"></a></p>
  
  <p>I tried a lots but cannot figure out how to do this. </p>