Export (0) Print
Expand All

ChMarker Object


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.
ChSeries
Aa190405.parchild(en-us,office.10).gifChMarker

Represents a data marker on a Line, XY (Scatter), Radar, or Polar chart.

Using the ChMarker object

The ChSeries object’s Marker property returns a 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

 

Show:
© 2014 Microsoft