This documentation is archived and is not being maintained.

ChartGroup.VaryByCategories Property 

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

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Dim chartGroup1 As ChartGroup

Dim returnValue As Boolean
returnValue = chartGroup1.VaryByCategories

Dim sampleValue As Boolean
chartGroup1.VaryByCategories = sampleValue

bool VaryByCategories {get; set;}
public boolean get_VaryByCategories();
public void set_VaryByCategories(boolean);
function get VaryByCategories() : Boolean;
function set VaryByCategories(Boolean);

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms