Patterned Method

Applies To

ChartFillFormat object.

Description

Sets a pattern for the specified fill.

Syntax

expression.Patterned(Pattern)

expression Required. An expression that returns a ChartFillFormat object.

Pattern Required Long. The pattern type. Can be one of the following MsoPatternType constants.

msoPattern5Percent	msoPattern10Percent
msoPattern20Percent	msoPattern25Percent
msoPattern30Percent	msoPattern40Percent
msoPattern50Percent	msoPattern60Percent
msoPattern70Percent	msoPattern75Percent
msoPattern80Percent	msoPattern90Percent
msoPatternDarkDownwardDiagonal	msoPatternDarkHorizontal
msoPatternDarkUpwardDiagonal	msoPatternDarkVertical
msoPatternDashedDownwardDiagonal	msoPatternDashedHorizontal
msoPatternDashedUpwardDiagonal	msoPatternDashedVertical

(continued)

msoPatternDiagonalBrick	msoPatternDivot
msoPatternDottedGrid	msoPatternHorizontalBrick
msoPatternLargeCheckerBoard	msoPatternLargeConfetti
msoPatternLargeGrid	msoPatternLightDownwardDiagonal
msoPatternLightHorizontal	msoPatternLightUpwardDiagonal
msoPatternLightVertical	msoPatternMixed
msoPatternNarrowHorizontal	msoPatternNarrowVertical
msoPatternOutlinedDiamond	msoPatternPlaid
msoPatternShingle	msoPatternSmallCheckerBoard
msoPatternSmallConfetti	msoPatternSmallGrid
msoPatternSolidDiamond	msoPatternSphere
msoPatternTrellis	msoPatternWave
msoPatternWeave	msoPatternWideDownwardDiagonal
msoPatternWideUpwardDiagonal	msoPatternZigZag

Example

This example sets the fill pattern.

With myChart.ChartArea.Fill
    .Patterned msoPatternDiagonalBrick
    .Visible = True
End With