title: Change color of data series in excel xyscatter chart
body: <p>I'm trying to change the color of the data points in an excel chart but everything im trying unsuccessful.</p>
  
  <p>This is one method I tried, yet the points still appear blue:</p>
  
  <pre><code>With Chrt
  .ChartType = xlXYScatter
  Do Until .SeriesCollection.Count = 0
  .SeriesCollection(1).Delete
  Loop
      .SeriesCollection.NewSeries
  
                  .SeriesCollection(1).Name = "=""Top Platen"""
                  .SeriesCollection(1).Values = yaxis
                  .SeriesCollection(1).XValues = xaxis
  
                  ActiveChart.SeriesCollection(1).Select
                   With Selection.Format.Fill
                      .Visible = msoTrue
                      .ForeColor.RGB = RGB(255, 0, 0)
                      .Transparency = 0
                      .Solid
                  End With
  </code></pre>
  
  <p>Here's another method I tried and still the data points appear blue:</p>
  
  <pre><code>With Chrt
  .ChartType = xlXYScatter
  Do Until .SeriesCollection.Count = 0
  .SeriesCollection(1).Delete
  Loop
      .SeriesCollection.NewSeries
  
                  .SeriesCollection(1).Name = "=""Top Platen"""
                  .SeriesCollection(1).Values = yaxis
                  .SeriesCollection(1).XValues = xaxis
                  .SeriesCollection(1).Interior.Color = RGB(255,0,0)
  </code></pre>
  
  <p>This is only one segment of my code, I can supply additional areas if necessary. Any help would be greatly appreciated. </p>