Application.ScreenUpdating = False
Application.Calculate
With Sheets(1)
If .ChartObjects.Count Then .ChartObjects.Delete
A = .Range("A2:L" & .Cells(Rows.Count, 1).End(xlUp).Row)
.Cells(UBound(A) + 3, 1).Select
End With
With ActiveSheet.Shapes.AddChart
.Chart.ChartType = xlXYScatter
.Left = 200: .Top = 70: .Width = 480: .Height = 320
For j = 1 To UBound(A, 2) - 1 Step 2
s = s + 1
.Chart.SeriesCollection.NewSeries
.Chart.SeriesCollection(s).XValues = Application.Index(A, 0, j)
.Chart.SeriesCollection(s).Values = Application.Index(A, 0, j + 1)
.Chart.SeriesCollection(s).Name = Left(Cells(1, j), 3)
.Chart.SeriesCollection(s).MarkerStyle = 8
.Chart.SeriesCollection(s).Format.Fill.ForeColor.RGB = Cells(1, j).Interior.Color
Next j
End With
End Sub