Marker Size and Marker Style

The MarkerSize property returns or sets the size of a data point in points (as a Long). The property also applies to the Series object, in which case it sets all markers in the series at once.

The MarkerStyle property determines the style of the data point and can be one of the following values:

Enum XlMarkerStyle xlMarkerStyleX = -4168 xlMarkerStylePicture = -4147 xlMarkerStyleNone = -4142 xlMarkerStyleDot = -4118 xlMarkerStyleDash = -4115 xlMarkerStyleAutomatic = -4105 xlMarkerStyleSquare = 1 xlMarkerStyleDiamond = 2 xlMarkerStyleTriangle = 3 xlMarkerStyleStar = 5 xlMarkerStyleCircle = 8 xlMarkerStylePlus = 9 End Enum

To illustrate, the following code produces the rather odd-looking chart in Figure 21-29.

With ActiveChart.SeriesCollection(1) .MarkerSize = 10

.MarkerStyle = xlMarkerStyleDiamond With .Points(2)

.MarkerSize = 20

.MarkerStyle = xlMarkerStyleCircle End With End With

Tea387 ly®

Figure 21-29. Illustrating MarkerSize and MarkerStyle

Figure 21-29. Illustrating MarkerSize and MarkerStyle

Marker Size Excel

Was this article helpful?

+4 -3

Responses

  • FELICITY CRAIG
    How to get value of marker size of data points using macro?
    8 years ago
  • florian gloeckner
    How to change size of data marker in excel chart legend?
    4 months ago

Post a comment