Syntax

expression.VaryByCategories

expression A variable that represents a ChartGroup object.

Example

This example assigns a different color or pattern to each data marker in chart group one. The example should be run on a 2-D line chart that has data markers on a series.

Visual Basic for Applications 
Charts("Chart1").ChartGroups(1).VaryByCategories = True
Assign a different color to each marker in a single series? Draw unique data markers? Pattern each symbol differently on a line chart? vary vary by categories Vary By Categories Property varyby VaryByCategories VaryByCategories Property

See also: