Urgent! How to Resize Pointers on Scatterplot VBA Excel

[ma3]

Hey, I've created a program to calculate Coil Voltages. For each voltages, there are 256 points. The dots on the scatterplot is too big and currently I had a hard time on resizing it to be smaller.

Those below are the codes on creating scatterplot for one coil voltage:

'Create Graph For Coil1
With ActiveSheet.ChartObjects.Add _
(Left:=110, Width:=375, Top:=55, Height:=225)
.Chart.SetSourceData Source:=Sheets("Program").Range("A9:IV9")
.Chart.ChartType = xlXYScatterLines

End With

'Create Graph Heading For Coil1
With Worksheets("Program").ChartObjects(1).Chart
.HasTitle = True
.ChartTitle.Text = "Coil 1"

End With

 

[davesweep]

Hi,

This should get you started...

For x = 1 To activechart.seriescollection(1).Points.Count
activechart.seriescollection(1).points(x).MarkerSize = 3
next x

 

[ma3]

I did insert the code and I get Object Variable or With Variable not set.

 

[davesweep]

Can you post the code as it appears in your workbook?