how do i get my skater plot to do just dots and not shapes too

[Boogerbut74]

Sub Test_6()


Dim lastrow As Integer
lastrow = Cells(Rows.Count, 10).End(xlUp).Row

'setting x and y axis
Set yData = ActiveSheet.Range("F11:t" & lastrow)
Set xData = ActiveSheet.Range("D11:D" & lastrow)
Set GraphRange = Union(xData, yData)

'Create a chart
   Set cht = ActiveSheet.ChartObjects.Add( _
    Left:=ActiveCell.Left, _
    Width:=450, _
    Top:=ActiveCell.Top, _
    Height:=250)





'Give chart some data
  cht.Chart.SetSourceData Source:=GraphRange


'Determine the chart type
cht.Chart.ChartType = xlXYScatterSmooth
 'edits chart detailes
cht.Chart.Axes(xlCategory).MinimumScale = 0
cht.Chart.Axes(xlCategory).MaximumScale = 100

cht.Chart.Axes(xlValue).MinimumScale = 115
cht.Chart.Axes(xlValue).MaximumScale = 140

cht.Chart.Legend.Position = xlLegendPositionBottom
 
  
End Sub

 

[rlv01]

Perhaps you could add text to explain what you mean. I'm not sure it is safe for you to assume your post title explains everything.

 

[Boogerbut74]

right now my skater plot has triangles squares lines etc. to show the plotted points, and i want it just to be circular filled in dots dots

 

[rlv01]

The purpose of line markers is to distinguish one data series from another. Having them all be circles defeats the purpose of that. You would be better off not using any markers

'Determine the chart type
cht.Chart.ChartType = xlXYScatterSmoothNoMarkers