Good Morning.

I've created a Macro to analyse all data in a selected folder.

The macro opens each file, completes some basic formatting, and then create a chart. All data are in columns A to M. X axis being the A culumn and B to M being in the Y axis.

Currently in some cases the data picks up at random points. When all data ranges should start from cell2 of each column.

Here's my code for the chart....

'Chart code here

ActiveSheet.Shapes.AddChart2(240, xlXYScatterSmoothNoMarkers).Select

Dim s

For m = 2 To 11
Set s = ActiveChart.SeriesCollection.NewSeries()
With s
.Name = Range("B" & m)
.XValues = Range("A" & m)
.Values = Range("B" & m)
End With
Next m