This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
Represents a data marker on a Line, XY (Scatter), Radar, or Polar chart.
Using the ChMarker object
Use the Size and Style properties to format ChMarker objects.
The following example converts the first series in the first chart of Chartspace1 to a line chart, and then formats the markers on the line.
Sub FormatMarkers() Dim serSeries1 Dim chConstants Set chConstants = ChartSpace1.Constants ' Set a variable to the first series of the first chart ' in Chartspace1. Set serSeries1 = ChartSpace1.Charts(0).SeriesCollection(0) ' Change the type of the first data series to a line chart. serSeries1.Type = chConstants.chChartTypeLineMarkers ' Set the marker style. serSeries1.Marker.Style = chConstants.chMarkerStyleDiamond ' Set the size of the markers. serSeries1.Marker.Size = 7 End Sub