How to control the number of markers in a chart?

hakeemniyas · Feb 27, 2017

I would like to plot a graph (having 1000 data - both x & y) using scatter plot with smooth line and markers.

It shows 1000 markers - but I want only say about 10 markers to show.

How to do this?

Note: The plot should contain all the 1000 data (smooth) and only 10 markers.

p45cal · Feb 28, 2017

Something like this (select the chart first):

Code:

Sub blah()
With ActiveChart
Set yyy = .SeriesCollection(1)
Z = UBound(yyy.Values) \ 11
  For i = 1 To UBound(yyy.Values)
    If i Mod Z <> 0 Then yyy.Points(i).MarkerStyle = -4142
  Next i
End With
End Sub

How to control the number of markers in a chart?

hakeemniyas

New member

p45cal

Super Moderator