Patterned Method

Applies To

ChartFillFormat object, FillFormat object.

Description

Sets the specified fill to a pattern.

Syntax

expression.Patterned(Pattern)

expression Required. An expression that returns a FillFormat object.

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

msoPattern10Percent	msoPattern20Percent
msoPattern25Percent	msoPattern30Percent
msoPattern40Percent	msoPattern50Percent
msoPattern5Percent	msoPattern60Percent
msoPattern70Percent	msoPattern75Percent
msoPattern80Percent	msoPattern90Percent
msoPatternDarkDownwardDiagonal	msoPatternDarkHorizontal
msoPatternDarkUpwardDiagonal	msoPatternDarkVertical
msoPatternDashedDownwardDiagonal	msoPatternDashedHorizontal
msoPatternDashedUpwardDiagonal	msoPatternDashedVertical
msoPatternDiagonalBrick	msoPatternDivits
msoPatternDottedGrid	msoPatternHorizontalBrick
msoPatternLargeCheckerBoard	msoPatternLargeConfetti
msoPatternLargeGrid	msoPatternLightDiamonds
msoPatternLightDownwardDiagonal	msoPatternLightHorizontal
msoPatternLightUpwardDiagonal	msoPatternLightVertical
msoPatternMixed	msoPatternNarrowHorizontal
msoPatternNarrowVertical	msoPatternOutlinedDiamonds
msoPatternPlaid	msoPatternShingles

msoPatternSmallCheckerBoard	msoPatternSmallConfetti
msoPatternSmallGrid	msoPatternSolidDiamonds
msoPatternSpheres	msoPatternTrellis
msoPatternWaves	msoPatternWavyLines
msoPatternWeave	msoPatternWideDownwardDiagonal
msoPatternWideUpwardDiagonal

Example

This example sets the fill pattern for chart one.

With Charts(1).ChartArea.Fill
    .Patterned msoPatternDiagonalBrick
    .Visible = True
End With