Expand Minimize

MarkerStyle Property

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

XlMarkerStyle can be one of these XlMarkerStyle constants.

xlMarkerStyleCircle. Circular markers

xlMarkerStyleDiamond. Diamond-shaped markers

xlMarkerStyleNone. No markers

xlMarkerStylePlus. Square markers with a plus sign

xlMarkerStyleStar. Square markers with an asterisk

xlMarkerStyleX. Square markers with an X

xlMarkerStyleAutomatic. Automatic markers

xlMarkerStyleDash. Long bar markers

xlMarkerStyleDot. Short bar markers

xlMarkerStylePicture. Picture markers

xlMarkerStyleSquare. Square markers

xlMarkerStyleTriangle. Triangular markers

expression.MarkerStyle

expression Required. An expression that returns one of the objects in the Applies To list.

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

myChart.SeriesCollection(1).MarkerStyle = xlMarkerStyleCircle
Show:
© 2014 Microsoft