Enumerations (Graph Visual Basic reference)

This topic provides a list of all enumerations in the Graph object model.

For more detailed descriptions, see the following:

• Enumerations (Excel)
• Enumerations (Office)

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

XlCopyPictureFormat

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

XlInsertFormatOrigin

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

XlPivotFormatType

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

XlWebFormatting

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.