Enumerations (Graph Visual Basic reference)
Article 09/13/2021
5 contributors
Feedback
In this article
This topic provides a list of all enumerations in the Graph object model.
For more detailed descriptions, see the following:
XlArabicModes
Name
Value
xlArabicBothStrict
3
xlArabicNone
0
xlArabicStrictAlefHamza
1
xlArabicStrictFinalYaa
2
XlArrowHeadLength
Name
Value
xlArrowHeadLengthLong
3
xlArrowHeadLengthMedium
-4138
xlArrowHeadLengthShort
1
XlArrowHeadStyle
Name
Value
xlArrowHeadStyleClosed
3
xlArrowHeadStyleDoubleClosed
5
xlArrowHeadStyleDoubleOpen
4
xlArrowHeadStyleNone
-4142
xlArrowHeadStyleOpen
2
XlArrowHeadWidth
Name
Value
xlArrowHeadWidthMedium
-4138
xlArrowHeadWidthNarrow
1
xlArrowHeadWidthWide
3
XlAxisCrosses
Name
Value
xlAxisCrossesAutomatic
-4105
xlAxisCrossesCustom
-4114
xlAxisCrossesMaximum
2
xlAxisCrossesMinimum
4
XlAxisGroup
Name
Value
xlPrimary
1
xlSecondary
2
XlAxisType
Name
Value
xlCategory
1
xlSeriesAxis
3
xlValue
2
XlBackground
Name
Value
xlBackgroundAutomatic
-4105
xlBackgroundOpaque
3
xlBackgroundTransparent
2
XlBarShape
Name
Value
xlBox
0
xlConeToMax
5
xlConeToPoint
4
xlCylinder
3
xlPyramidToMax
2
xlPyramidToPoint
1
XlBorderWeight
Name
Value
xlHairline
1
xlMedium
-4138
xlThick
4
xlThin
2
XlCalculatedMemberType
Name
Value
xlCalculatedMember
0
xlCalculatedSet
1
XlCategoryType
Name
Value
xlAutomaticScale
-4105
xlCategoryScale
2
xlTimeScale
3
XlChartGallery
Name
Value
xlAnyGallery
23
xlBuiltIn
21
xlUserDefined
22
XlChartItem
Name
Value
xlAxis
21
xlAxisTitle
17
xlChartArea
2
xlChartTitle
4
xlCorners
6
xlDataLabel
0
xlDataTable
7
xlDisplayUnitLabel
30
xlDownBars
20
xlDropLines
26
xlErrorBars
9
xlFloor
23
xlHiLoLines
25
xlLeaderLines
29
xlLegend
24
xlLegendEntry
12
xlLegendKey
13
xlMajorGridlines
15
xlMinorGridlines
16
xlNothing
28
xlPivotChartDropZone
32
xlPivotChartFieldButton
31
xlPlotArea
19
xlRadarAxisLabels
27
xlSeries
3
xlSeriesLines
22
xlShape
14
xlTrendline
8
xlUpBars
18
xlWalls
5
xlXErrorBars
10
xlYErrorBars
11
XlChartPicturePlacement
Name
Value
xlAllFaces
7
xlEnd
2
xlEndSides
3
xlFront
4
xlFrontEnd
6
xlFrontSides
5
xlSides
1
XlChartPictureType
Name
Value
xlStack
2
xlStackScale
3
xlStretch
1
XlChartSplitType
Name
Value
xlSplitByCustomSplit
4
xlSplitByPercentValue
3
xlSplitByPosition
1
xlSplitByValue
2
XlChartType
Name
Value
xl3DArea
-4098
xl3DAreaStacked
78
xl3DAreaStacked100
79
xl3DBarClustered
60
xl3DBarStacked
61
xl3DBarStacked100
62
xl3DColumn
-4100
xl3DColumnClustered
54
xl3DColumnStacked
55
xl3DColumnStacked100
56
xl3DLine
-4101
xl3DPie
-4102
xl3DPieExploded
70
xlArea
1
xlAreaStacked
76
xlAreaStacked100
77
xlBarClustered
57
xlBarOfPie
71
xlBarStacked
58
xlBarStacked100
59
xlBubble
15
xlBubble3DEffect
87
xlColumnClustered
51
xlColumnStacked
52
xlColumnStacked100
53
xlConeBarClustered
102
xlConeBarStacked
103
xlConeBarStacked100
104
xlConeCol
105
xlConeColClustered
99
xlConeColStacked
100
xlConeColStacked100
101
xlCylinderBarClustered
95
xlCylinderBarStacked
96
xlCylinderBarStacked100
97
xlCylinderCol
98
xlCylinderColClustered
92
xlCylinderColStacked
93
xlCylinderColStacked100
94
xlDoughnut
-4120
xlDoughnutExploded
80
xlLine
4
xlLineMarkers
65
xlLineMarkersStacked
66
xlLineMarkersStacked100
67
xlLineStacked
63
xlLineStacked100
64
xlPie
5
xlPieExploded
69
xlPieOfPie
68
xlPyramidBarClustered
109
xlPyramidBarStacked
110
xlPyramidBarStacked100
111
xlPyramidCol
112
xlPyramidColClustered
106
xlPyramidColStacked
107
xlPyramidColStacked100
108
xlRadar
-4151
xlRadarFilled
82
xlRadarMarkers
81
xlStockHLC
88
xlStockOHLC
89
xlStockVHLC
90
xlStockVOHLC
91
xlSurface
83
xlSurfaceTopView
85
xlSurfaceTopViewWireframe
86
xlSurfaceWireframe
84
xlXYScatter
-4169
xlXYScatterLines
74
xlXYScatterLinesNoMarkers
75
xlXYScatterSmooth
72
xlXYScatterSmoothNoMarkers
73
XlCmdType
Name
Value
xlCmdCube
1
xlCmdDefault
4
xlCmdList
5
xlCmdSql
2
xlCmdTable
3
XlColorIndex
Name
Value
xlColorIndexAutomatic
-4105
xlColorIndexNone
-4142
XlColumnDataType
Name
Value
xlDMYFormat
4
xlDYMFormat
7
xlEMDFormat
10
xlGeneralFormat
1
xlMDYFormat
3
xlMYDFormat
6
xlSkipColumn
9
xlTextFormat
2
xlYDMFormat
8
xlYMDFormat
5
XlConsolidationFunction
Name
Value
xlAverage
-4106
xlCount
-4112
xlCountNums
-4113
xlMax
-4136
xlMin
-4139
xlProduct
-4149
xlStDev
-4155
xlStDevP
-4156
xlSum
-4157
xlUnknown
1000
xlVar
-4164
xlVarP
-4165
Name
Value
xlBitmap
2
xlPicture
-4147
XlCreator
Name
Value
xlCreatorCode
1480803660
XlCubeFieldType
Name
Value
xlHierarchy
1
xlMeasure
2
xlSet
3
XlDataLabelPosition
Name
Value
xlLabelPositionAbove
0
xlLabelPositionBelow
1
xlLabelPositionBestFit
5
xlLabelPositionCenter
-4108
xlLabelPositionCustom
7
xlLabelPositionInsideBase
4
xlLabelPositionInsideEnd
3
xlLabelPositionLeft
-4131
xlLabelPositionMixed
6
xlLabelPositionOutsideEnd
2
xlLabelPositionRight
-4152
XlDataLabelSeparator
Name
Value
xlDataLabelSeparatorDefault
1
XlDataLabelsType
Name
Value
xlDataLabelsShowBubbleSizes
6
xlDataLabelsShowLabel
4
xlDataLabelsShowLabelAndPercent
5
xlDataLabelsShowNone
-4142
xlDataLabelsShowPercent
3
xlDataLabelsShowValue
2
XlDataSeriesDate
Name
Value
xlDay
1
xlMonth
3
xlWeekday
2
xlYear
4
XlDataSeriesType
Name
Value
xlAutoFill
4
xlChronological
3
xlDataSeriesLinear
-4132
xlGrowth
2
XlDeleteShiftDirection
Name
Value
xlShiftToLeft
-4159
xlShiftUp
-4162
XlDirection
Name
Value
xlDown
-4121
xlToLeft
-4159
xlToRight
-4161
xlUp
-4162
XlDisplayBlanksAs
Name
Value
xlInterpolated
3
xlNotPlotted
1
xlZero
2
XlDisplayDrawingObjects
Name
Value
xlDisplayShapes
-4104
xlHide
3
xlPlaceholders
2
XlDisplayUnit
Name
Value
xlHundredMillions
-8
xlHundreds
-2
xlHundredThousands
-5
xlMillionMillions
-10
xlMillions
-6
xlTenMillions
-7
xlTenThousands
-4
xlThousandMillions
-9
xlThousands
-3
XlEndStyleCap
Name
Value
xlCap
1
xlNoCap
2
XlErrorBarDirection
Name
Value
xlX
-4168
xlY
1
XlErrorBarInclude
Name
Value
xlErrorBarIncludeBoth
1
xlErrorBarIncludeMinusValues
3
xlErrorBarIncludeNone
-4142
xlErrorBarIncludePlusValues
2
XlErrorBarType
Name
Value
xlErrorBarTypeCustom
-4114
xlErrorBarTypeFixedValue
1
xlErrorBarTypePercent
2
xlErrorBarTypeStDev
-4155
xlErrorBarTypeStError
4
XlFindLookIn
Name
Value
xlComments
-4144
xlFormulas
-4123
xlValues
-4163
XlHAlign
Name
Value
xlHAlignCenter
-4108
xlHAlignCenterAcrossSelection
7
xlHAlignDistributed
-4117
xlHAlignFill
5
xlHAlignGeneral
1
xlHAlignJustify
-4130
xlHAlignLeft
-4131
xlHAlignRight
-4152
XlHebrewModes
Name
Value
xlHebrewFullScript
0
xlHebrewMixedAuthorizedScript
3
xlHebrewMixedScript
2
xlHebrewPartialScript
1
XlImportDataAs
Name
Value
xlPivotTableReport
1
xlQueryTable
0
Name
Value
xlFormatFromLeftOrAbove
0
xlFormatFromRightOrBelow
1
XlInsertShiftDirection
Name
Value
xlShiftDown
-4121
xlShiftToRight
-4161
XlLegendPosition
Name
Value
xlLegendPositionBottom
-4107
xlLegendPositionCorner
2
xlLegendPositionLeft
-4131
xlLegendPositionRight
-4152
xlLegendPositionTop
-4160
XlLineStyle
Name
Value
xlContinuous
1
xlDash
-4115
xlDashDot
4
xlDashDotDot
5
xlDot
-4118
xlDouble
-4119
xlLineStyleNone
-4142
xlSlantDashDot
13
XlLocationInTable
Name
Value
xlColumnHeader
-4110
xlColumnItem
5
xlDataHeader
3
xlDataItem
7
xlPageHeader
2
xlPageItem
6
xlRowHeader
-4153
xlRowItem
4
xlTableBody
8
XlMarkerStyle
Name
Value
xlMarkerStyleAutomatic
-4105
xlMarkerStyleCircle
8
xlMarkerStyleDash
-4115
xlMarkerStyleDiamond
2
xlMarkerStyleDot
-4118
xlMarkerStyleNone
-4142
xlMarkerStylePicture
-4147
xlMarkerStylePlus
9
xlMarkerStyleSquare
1
xlMarkerStyleStar
5
xlMarkerStyleTriangle
3
xlMarkerStyleX
-4168
XlOrientation
Name
Value
xlDownward
-4170
xlHorizontal
-4128
xlUpward
-4171
xlVertical
-4166
XlPattern
Name
Value
xlPatternAutomatic
-4105
xlPatternChecker
9
xlPatternCrissCross
16
xlPatternDown
-4121
xlPatternGray16
17
xlPatternGray25
-4124
xlPatternGray50
-4125
xlPatternGray75
-4126
xlPatternGray8
18
xlPatternGrid
15
xlPatternHorizontal
-4128
xlPatternLightDown
13
xlPatternLightHorizontal
11
xlPatternLightUp
14
xlPatternLightVertical
12
xlPatternNone
-4142
xlPatternSemiGray75
10
xlPatternSolid
1
xlPatternUp
-4162
xlPatternVertical
-4166
XlPictureConvertorType
Name
Value
xlBMP
1
xlCGM
7
xlDRW
4
xlDXF
5
xlEPS
8
xlHGL
6
xlPCT
13
xlPCX
10
xlPIC
11
xlPLT
12
xlTIF
9
xlWMF
2
xlWPG
3
XlPivotFieldDataType
Name
Value
xlDate
2
xlNumber
-4145
xlText
-4158
Name
Value
xlPTClassic
20
xlPTNone
21
xlReport1
0
xlReport10
9
xlReport2
1
xlReport3
2
xlReport4
3
xlReport5
4
xlReport6
5
xlReport7
6
xlReport8
7
xlReport9
8
xlTable1
10
xlTable10
19
xlTable2
11
xlTable3
12
xlTable4
13
xlTable5
14
xlTable6
15
xlTable7
16
xlTable8
17
xlTable9
18
XlPivotTableSourceType
Name
Value
xlConsolidation
3
xlDatabase
1
xlExternal
2
xlPivotTable
-4148
xlScenario
4
XlQueryType
Name
Value
xlADORecordset
7
xlDAORecordset
2
xlODBCQuery
1
xlOLEDBQuery
5
xlTextImport
6
xlWebQuery
4
XlRangeValueDataType
Name
Value
xlRangeValueDefault
10
xlRangeValueMSPersistXML
12
xlRangeValueXMLSpreadsheet
11
XlReferenceStyle
Name
Value
xlA1
1
xlR1C1
-4150
XlRowCol
Name
Value
xlColumns
2
xlRows
1
XlScaleType
Name
Value
xlScaleLinear
-4132
xlScaleLogarithmic
-4133
XlSheetType
Name
Value
xlChart
-4109
xlDialogSheet
-4116
xlExcel4IntlMacroSheet
4
xlExcel4MacroSheet
3
xlWorksheet
-4167
XlSizeRepresents
Name
Value
xlSizeIsArea
1
xlSizeIsWidth
2
XlSubtotalLocationType
Name
Value
xlAtBottom
2
xlAtTop
1
XlTickLabelOrientation
Name
Value
xlTickLabelOrientationAutomatic
-4105
xlTickLabelOrientationDownward
-4170
xlTickLabelOrientationHorizontal
-4128
xlTickLabelOrientationUpward
-4171
xlTickLabelOrientationVertical
-4166
XlTickLabelPosition
Name
Value
xlTickLabelPositionHigh
-4127
xlTickLabelPositionLow
-4134
xlTickLabelPositionNextToAxis
4
xlTickLabelPositionNone
-4142
XlTickMark
Name
Value
xlTickMarkCross
4
xlTickMarkInside
2
xlTickMarkNone
-4142
xlTickMarkOutside
3
XlTimeUnit
Name
Value
xlDays
0
xlMonths
1
xlYears
2
XlTrendlineType
Name
Value
xlExponential
5
xlLinear
-4132
xlLogarithmic
-4133
xlMovingAvg
6
xlPolynomial
3
xlPower
4
XlUnderlineStyle
Name
Value
xlUnderlineStyleDouble
-4119
xlUnderlineStyleDoubleAccounting
5
xlUnderlineStyleNone
-4142
xlUnderlineStyleSingle
2
xlUnderlineStyleSingleAccounting
4
XlVAlign
Name
Value
xlVAlignBottom
-4107
xlVAlignCenter
-4108
xlVAlignDistributed
-4117
xlVAlignJustify
-4130
xlVAlignTop
-4160
Name
Value
xlWebFormattingAll
1
xlWebFormattingNone
3
xlWebFormattingRTF
2
XlWebSelectionType
Name
Value
xlAllTables
2
xlEntirePage
1
xlSpecifiedTables
3
XlWindowState
Name
Value
xlMaximized
-4137
xlMinimized
-4140
xlNormal
-4143
XlWindowType
Name
Value
xlChartAsWindow
5
xlChartInPlace
4
xlClipboard
3
xlInfo
-4129
xlWorkbook
1
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.