Expand Minimize

XlPattern Enumeration (Excel)

Published: July 16, 2012

Specifies the interior pattern of a chart or interior object.

Version Added: Excel 2007

Name

Value

Description

xlPatternAutomatic

-4105

Excel controls the pattern.

xlPatternChecker

9

Checkerboard.

xlPatternCrissCross

16

Criss-cross lines.

xlPatternDown

-4121

Dark diagonal lines running from the upper left to the lower right.

xlPatternGray16

17

16% gray.

xlPatternGray25

-4124

25% gray.

xlPatternGray50

-4125

50% gray.

xlPatternGray75

-4126

75% gray.

xlPatternGray8

18

8% gray.

xlPatternGrid

15

Grid.

xlPatternHorizontal

-4128

Dark horizontal lines.

xlPatternLightDown

13

Light diagonal lines running from the upper left to the lower right.

xlPatternLightHorizontal

11

Light horizontal lines.

xlPatternLightUp

14

Light diagonal lines running from the lower left to the upper right.

xlPatternLightVertical

12

Light vertical bars.

xlPatternNone

-4142

No pattern.

xlPatternSemiGray75

10

75% dark moiré.

xlPatternSolid

1

Solid color.

xlPatternUp

-4162

Dark diagonal lines running from the lower left to the upper right.

xlPatternVertical

-4166

Dark vertical bars.

Community Additions

ADD
Show:
© 2014 Microsoft