Pattern Property

Applies To

ChartFillFormat object, Interior object.

Description

Interior object: Returns or sets the interior pattern. Read/write Long.

Can be one of the following XlPattern constants:

  • xlPatternAutomatic
  • xlPatternChecker
  • xlPatternCrissCross
  • xlPatternDown
  • xlPatternGray8
  • xlPatternGray16
  • xlPatternGray25
  • xlPatternGray50
  • xlPatternGray75
  • xlPatternGrid
  • xlPatternHorizontal
  • xlPatternLightDown
  • xlPatternLightHorizontal
  • xlPatternLightUp
  • xlPatternLightVertical
  • xlPatternNone
  • xlPatternSemiGray75
  • xlPatternSolid
  • xlPatternUp
  • xlPatternVertical

ChartFillFormat object: Returns or sets the fill pattern. Read-only Long.

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
  • 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

See Also

PatternColor property.

Example

This example adds a crisscross pattern to the interior of the plot area.

myChart.PlotArea.Interior.Pattern = xlPatternCrissCross