Excel.ChartGroup.VaryByCategories.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
ChartGroup.VaryByCategories property (Excel)	vbaxl10.chm568093	vbaxl10.chm568093	Excel.ChartGroup.VaryByCategories	9ae94a48-abc7-b692-7376-f4cb780a4063	04/20/2019	medium

ChartGroup.VaryByCategories property (Excel)

True if Microsoft Excel assigns a different color or pattern to each data marker. The chart must contain only one series. Read/write Boolean.

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 2D line chart that has data markers on a series.

Charts("Chart1").ChartGroups(1).VaryByCategories = True

[!includeSupport and feedback]