Skip to content

Latest commit

 

History

History
38 lines (26 loc) · 975 Bytes

Excel.XYGroups.md

File metadata and controls

38 lines (26 loc) · 975 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
XYGroups method (Excel Graph)
vbagr10.chm3077639
vbagr10.chm3077639
Excel.XYGroups
d334382a-8d27-2b35-4306-a16f5fa13c89
04/09/2019
medium

XYGroups method (Excel Graph)

On a 2D chart, returns an object that represents either a single scatter chart group or a collection of the scatter chart groups.

Syntax

expression.XYGroups (Index)

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

Parameters

Name Required/Optional Data type Description
Index Optional Variant Specifies the chart group.

Example

This example sets X-Y group (scatter group) one to use a different color for each data marker. The example should be run on a 2D chart.

myChart.XYGroups(1).VaryByCategories = True

[!includeSupport and feedback]