Skip to content

Latest commit

 

History

History
44 lines (29 loc) · 1.07 KB

Excel.ChartGroup.SeriesLines.md

File metadata and controls

44 lines (29 loc) · 1.07 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
ChartGroup.SeriesLines property (Excel)
vbaxl10.chm568089
vbaxl10.chm568089
Excel.ChartGroup.SeriesLines
3e2156c3-c4dd-ef22-1645-ba27e7b499b8
04/20/2019
medium

ChartGroup.SeriesLines property (Excel)

Returns a SeriesLines object that represents the series lines for a 2D stacked bar, 2D stacked column, Pie of Pie, or Bar of Pie chart. Read-only.

Syntax

expression.SeriesLines

expression A variable that represents a ChartGroup object.

Example

This example turns on series lines for chart group one on Chart1, and then sets their line style, weight, and color. The example should be run on a 2D stacked column chart that has two or more series.

With Charts("Chart1").ChartGroups(1) 
 .HasSeriesLines = True 
 With .SeriesLines.Border 
 .LineStyle = xlThin 
 .Weight = xlMedium 
 .ColorIndex = 3 
 End With 
End With

[!includeSupport and feedback]