Vba And Excel Object Model Quick Reference

EXCEL OBJECT MODEL CONSTANTS (CONTINUED)

XlChartType Constants (Continued)

CONSTANT

VALUE

CHARTTYPE

xlPyramidColStacked

107

Stacked Pyramid Column

xlPyramidColStacked10 0

108

100% Stacked Pyramid Column

xlRadar

-4151

Radar

xlRadarFilled

82

Filled Radar

xlRadarMarkers

81

Radar with Data Markers

xlStockHLC

88

High-Low-Close

xlStockOHLC

89

Open-High-Low-Close

xlStockVHLC

90

Volume-High-Low-Close

xlStockVOHLC

91

Volume-Open-High-Low-Close

xlSurface

83

3D Surface

xlSurfaceTopView

85

Top View Surface

xlSurfaceTopViewWireframe

86

Top View wireframe Surface

xlSurfaceWireframe

84

3D Surface wireframe

xlXYScatter

-4169

Scatter

xlXYScatterLines

74

Scatter with Lines.

xlXYScatterLinesNoMarkers

75

Scatter with Lines and No Data Markers

xlXYScatterSmooth

72

Scatter with Smoothed Lines

xlXYScatterSmoothNoMarkers

73

Scatter with Smoothed Lines and No Data Markers

XlLineStyle Constants

CONSTANT

VALUE

DESCRIPTION

xlContinuous

1

Continuous solid line.

xlDash

-4155

Dashed line.

xlDashDot

4

Line with the pattern dash dot.

xlDashDotDot

5

Line with the pattern dash dot dot.

xlDot

-4118

Dotted line.

xlDouble

-4119

Double solid line.

xlSlantDashDot

13

Slanted line with the pattern dash dot.

xlineStyleNone

-4142

No line.

EXCEL OBJECT MODEL CONSTANTS (CONTINUED)

XlBorderWeight Constants

CONSTANT

VALUE

DESCRIPTION

xlHairline

1

Creates a very thin line.

xlMedium

-4138

Creates a medium width line.

xlThick

4

Creates a thick line.

xlThin

2

Creates a thin line.

XlPattern Constants

CONSTANT

VALUE

DESCRIPTION

xlPatternAutomatic

-4105

System default.

xlPatternChecker

9

Checkered pattern.

xlPatternCrissCross

16

Criss-cross pattern.

xlPatternDown

-4121

Downward pattern.

xlPatternGray16

17

16% gray pattern.

xlPatternGray2 5

-4124

25% gray pattern.

xlPatternGray50

-4125

50% gray pattern.

xlPatternGray7 5

-4126

75% gray pattern.

xlPatternGray8

18

8% gray pattern.

xlPatternGrid

15

Grid pattern.

xlPatternHorizontal

-4128

Horizontal pattern.

xlPatternLightHorizontal

11

Light horizontal pattern.

xlPatternLightVertical

12

Light vertical pattern.

xlPatternLightDown

13

Light downward pattern.

xlPatternLightUp

14

Light upward pattern.

xlPatternNone

-4142

No pattern.

xlPatternSemiGray7 5

10

75% semi-gray pattern.

xlPatternSolid

1

Solid color, no pattern.

xlPatternUp

-4162

Upward pattern.

xlPatternVertical

-4166

Vertical pattern.

Was this article helpful?

0 0

Post a comment