Series.MarkerStyle Property

  • Article
Excel Developer Reference

Returns or sets the marker style for a point or series in a line chart, scatter chart, or radar chart. Read/write XlMarkerStyle.

Syntax

expression.MarkerStyle

expression   A variable that represents a Series object.

Remarks

XlMarkerStyle can be one of these XlMarkerStyle constants.
xlMarkerStyleAutomatic. Automatic markers
xlMarkerStyleCircle. Circular markers
xlMarkerStyleDash. Long bar markers
xlMarkerStyleDiamond. Diamond-shaped markers
xlMarkerStyleDot. Short bar markers
xlMarkerStyleNone. No markers
xlMarkerStylePicture. Picture markers
xlMarkerStylePlus. Square markers with a plus sign
xlMarkerStyleSquare. Square markers
xlMarkerStyleStar. Square markers with an asterisk
xlMarkerStyleTriangle. Triangular markers
xlMarkerStyleX. Square markers with an X

Example

This example sets the marker style for series one in Chart1. The example should be run on a 2-D line chart.

Visual Basic for Applications 
  Charts("Chart1").SeriesCollection(1) _
    .MarkerStyle = xlMarkerStyleCircle

See Also