This topic provides a list of all constants in the Graph object model.
XlArabicModes
| Constant
| Value
|
| xlArabicBothStrict
| 3
|
| xlArabicNone
| 0
|
| xlArabicStrictAlefHamza
| 1
|
| xlArabicStrictFinalYaa
| 2 |
XlArrowHeadLength
| Constant
| Value
|
| xlArrowHeadLengthLong
| 3
|
| xlArrowHeadLengthMedium
| -4138
|
| xlArrowHeadLengthShort
| 1 |
XlArrowHeadStyle
| Constant
| Value
|
| xlArrowHeadStyleClosed
| 3
|
| xlArrowHeadStyleDoubleClosed
| 5
|
| xlArrowHeadStyleDoubleOpen
| 4
|
| xlArrowHeadStyleNone
| -4142
|
| xlArrowHeadStyleOpen
| 2 |
XlArrowHeadWidth
| Constant
| Value
|
| xlArrowHeadWidthMedium
| -4138
|
| xlArrowHeadWidthNarrow
| 1
|
| xlArrowHeadWidthWide
| 3 |
XlAxisCrosses
| Constant
| Value
|
| xlAxisCrossesAutomatic
| -4105
|
| xlAxisCrossesCustom
| -4114
|
| xlAxisCrossesMaximum
| 2
|
| xlAxisCrossesMinimum
| 4 |
XlAxisGroup
| Constant
| Value
|
| xlPrimary
| 1
|
| xlSecondary
| 2 |
XlAxisType
| Constant
| Value
|
| xlCategory
| 1
|
| xlSeriesAxis
| 3
|
| xlValue
| 2 |
XlBackground
| Constant
| Value
|
| xlBackgroundAutomatic
| -4105
|
| xlBackgroundOpaque
| 3
|
| xlBackgroundTransparent
| 2 |
XlBarShape
| Constant
| Value
|
| xlBox
| 0
|
| xlConeToMax
| 5
|
| xlConeToPoint
| 4
|
| xlCylinder
| 3
|
| xlPyramidToMax
| 2
|
| xlPyramidToPoint
| 1 |
XlBorderWeight
| Constant
| Value
|
| xlHairline
| 1
|
| xlMedium
| -4138
|
| xlThick
| 4
|
| xlThin
| 2 |
XlCalculatedMemberType
| Constant
| Value
|
| xlCalculatedMember
| 0
|
| xlCalculatedSet
| 1 |
XlCategoryType
| Constant
| Value
|
| xlAutomaticScale
| -4105
|
| xlCategoryScale
| 2
|
| xlTimeScale
| 3 |
XlChartGallery
| Constant
| Value
|
| xlAnyGallery
| 23
|
| xlBuiltIn
| 21
|
| xlUserDefined
| 22 |
XlChartItem
| Constant
| 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
| Constant
| Value
|
| xlAllFaces
| 7
|
| xlEnd
| 2
|
| xlEndSides
| 3
|
| xlFront
| 4
|
| xlFrontEnd
| 6
|
| xlFrontSides
| 5
|
| xlSides
| 1 |
XlChartPictureType
| Constant
| Value
|
| xlStack
| 2
|
| xlStackScale
| 3
|
| xlStretch
| 1 |
XlChartSplitType
| Constant
| Value
|
| xlSplitByCustomSplit
| 4
|
| xlSplitByPercentValue
| 3
|
| xlSplitByPosition
| 1
|
| xlSplitByValue
| 2 |
XlChartType
| Constant
| 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
| Constant
| Value
|
| xlCmdCube
| 1
|
| xlCmdDefault
| 4
|
| xlCmdList
| 5
|
| xlCmdSql
| 2
|
| xlCmdTable
| 3 |
XlColorIndex
| Constant
| Value
|
| xlColorIndexAutomatic
| -4105
|
| xlColorIndexNone
| -4142 |
XlColumnDataType
| Constant
| Value
|
| xlDMYFormat
| 4
|
| xlDYMFormat
| 7
|
| xlEMDFormat
| 10
|
| xlGeneralFormat
| 1
|
| xlMDYFormat
| 3
|
| xlMYDFormat
| 6
|
| xlSkipColumn
| 9
|
| xlTextFormat
| 2
|
| xlYDMFormat
| 8
|
| xlYMDFormat
| 5 |
XlConsolidationFunction
| Constant
| 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
| Constant
| Value
|
| xlBitmap
| 2
|
| xlPicture
| -4147 |
XlCreator
| Constant
| Value
|
| xlCreatorCode
| 1480803660 |
XlCubeFieldType
| Constant
| Value
|
| xlHierarchy
| 1
|
| xlMeasure
| 2
|
| xlSet
| 3 |
XlDataLabelPosition
| Constant
| Value
|
| xlLabelPositionAbove
| 0
|
| xlLabelPositionBelow
| 1
|
| xlLabelPositionBestFit
| 5
|
| xlLabelPositionCenter
| -4108
|
| xlLabelPositionCustom
| 7
|
| xlLabelPositionInsideBase
| 4
|
| xlLabelPositionInsideEnd
| 3
|
| xlLabelPositionLeft
| -4131
|
| xlLabelPositionMixed
| 6
|
| xlLabelPositionOutsideEnd
| 2
|
| xlLabelPositionRight
| -4152 |
XlDataLabelSeparator
| Constant
| Value
|
| xlDataLabelSeparatorDefault
| 1 |
XlDataLabelsType
| Constant
| Value
|
| xlDataLabelsShowBubbleSizes
| 6
|
| xlDataLabelsShowLabel
| 4
|
| xlDataLabelsShowLabelAndPercent
| 5
|
| xlDataLabelsShowNone
| -4142
|
| xlDataLabelsShowPercent
| 3
|
| xlDataLabelsShowValue
| 2 |
XlDataSeriesDate
| Constant
| Value
|
| xlDay
| 1
|
| xlMonth
| 3
|
| xlWeekday
| 2
|
| xlYear
| 4 |
XlDataSeriesType
| Constant
| Value
|
| xlAutoFill
| 4
|
| xlChronological
| 3
|
| xlDataSeriesLinear
| -4132
|
| xlGrowth
| 2 |
XlDeleteShiftDirection
| Constant
| Value
|
| xlShiftToLeft
| -4159
|
| xlShiftUp
| -4162 |
XlDirection
| Constant
| Value
|
| xlDown
| -4121
|
| xlToLeft
| -4159
|
| xlToRight
| -4161
|
| xlUp
| -4162 |
XlDisplayBlanksAs
| Constant
| Value
|
| xlInterpolated
| 3
|
| xlNotPlotted
| 1
|
| xlZero
| 2 |
XlDisplayDrawingObjects
| Constant
| Value
|
| xlDisplayShapes
| -4104
|
| xlHide
| 3
|
| xlPlaceholders
| 2 |
XlDisplayUnit
| Constant
| Value
|
| xlHundredMillions
| -8
|
| xlHundreds
| -2
|
| xlHundredThousands
| -5
|
| xlMillionMillions
| -10
|
| xlMillions
| -6
|
| xlTenMillions
| -7
|
| xlTenThousands
| -4
|
| xlThousandMillions
| -9
|
| xlThousands
| -3 |
XlEndStyleCap
| Constant
| Value
|
| xlCap
| 1
|
| xlNoCap
| 2 |
XlErrorBarDirection
| Constant
| Value
|
| xlX
| -4168
|
| xlY
| 1 |
XlErrorBarInclude
| Constant
| Value
|
| xlErrorBarIncludeBoth
| 1
|
| xlErrorBarIncludeMinusValues
| 3
|
| xlErrorBarIncludeNone
| -4142
|
| xlErrorBarIncludePlusValues
| 2 |
XlErrorBarType
| Constant
| Value
|
| xlErrorBarTypeCustom
| -4114
|
| xlErrorBarTypeFixedValue
| 1
|
| xlErrorBarTypePercent
| 2
|
| xlErrorBarTypeStDev
| -4155
|
| xlErrorBarTypeStError
| 4 |
XlFindLookIn
| Constant
| Value
|
| xlComments
| -4144
|
| xlFormulas
| -4123
|
| xlValues
| -4163 |
XlHAlign
| Constant
| Value
|
| xlHAlignCenter
| -4108
|
| xlHAlignCenterAcrossSelection
| 7
|
| xlHAlignDistributed
| -4117
|
| xlHAlignFill
| 5
|
| xlHAlignGeneral
| 1
|
| xlHAlignJustify
| -4130
|
| xlHAlignLeft
| -4131
|
| xlHAlignRight
| -4152 |
XlHebrewModes
| Constant
| Value
|
| xlHebrewFullScript
| 0
|
| xlHebrewMixedAuthorizedScript
| 3
|
| xlHebrewMixedScript
| 2
|
| xlHebrewPartialScript
| 1 |
XlImportDataAs
| Constant
| Value
|
| xlPivotTableReport
| 1
|
| xlQueryTable
| 0 |
XlInsertFormatOrigin
| Constant
| Value
|
| xlFormatFromLeftOrAbove
| 0
|
| xlFormatFromRightOrBelow
| 1 |
XlInsertShiftDirection
| Constant
| Value
|
| xlShiftDown
| -4121
|
| xlShiftToRight
| -4161 |
XlLegendPosition
| Constant
| Value
|
| xlLegendPositionBottom
| -4107
|
| xlLegendPositionCorner
| 2
|
| xlLegendPositionLeft
| -4131
|
| xlLegendPositionRight
| -4152
|
| xlLegendPositionTop
| -4160 |
XlLineStyle
| Constant
| Value
|
| xlContinuous
| 1
|
| xlDash
| -4115
|
| xlDashDot
| 4
|
| xlDashDotDot
| 5
|
| xlDot
| -4118
|
| xlDouble
| -4119
|
| xlLineStyleNone
| -4142
|
| xlSlantDashDot
| 13 |
XlLocationInTable
| Constant
| Value
|
| xlColumnHeader
| -4110
|
| xlColumnItem
| 5
|
| xlDataHeader
| 3
|
| xlDataItem
| 7
|
| xlPageHeader
| 2
|
| xlPageItem
| 6
|
| xlRowHeader
| -4153
|
| xlRowItem
| 4
|
| xlTableBody
| 8 |
XlMarkerStyle
| Constant
| 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
| Constant
| Value
|
| xlDownward
| -4170
|
| xlHorizontal
| -4128
|
| xlUpward
| -4171
|
| xlVertical
| -4166 |
XlPattern
| Constant
| 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
| Constant
| 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
| Constant
| Value
|
| xlDate
| 2
|
| xlNumber
| -4145
|
| xlText
| -4158 |
XlPivotFormatType
| Constant
| 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
| Constant
| Value
|
| xlConsolidation
| 3
|
| xlDatabase
| 1
|
| xlExternal
| 2
|
| xlPivotTable
| -4148
|
| xlScenario
| 4 |
XlQueryType
| Constant
| Value
|
| xlADORecordset
| 7
|
| xlDAORecordset
| 2
|
| xlODBCQuery
| 1
|
| xlOLEDBQuery
| 5
|
| xlTextImport
| 6
|
| xlWebQuery
| 4 |
XlRangeValueDataType
| Constant
| Value
|
| xlRangeValueDefault
| 10
|
| xlRangeValueMSPersistXML
| 12
|
| xlRangeValueXMLSpreadsheet
| 11 |
XlReferenceStyle
| Constant
| Value
|
| xlA1
| 1
|
| xlR1C1
| -4150 |
XlRowCol
| Constant
| Value
|
| xlColumns
| 2
|
| xlRows
| 1 |
XlScaleType
| Constant
| Value
|
| xlScaleLinear
| -4132
|
| xlScaleLogarithmic
| -4133 |
XlSheetType
| Constant
| Value
|
| xlChart
| -4109
|
| xlDialogSheet
| -4116
|
| xlExcel4IntlMacroSheet
| 4
|
| xlExcel4MacroSheet
| 3
|
| xlWorksheet
| -4167 |
XlSizeRepresents
| Constant
| Value
|
| xlSizeIsArea
| 1
|
| xlSizeIsWidth
| 2 |
XlSubtototalLocationType
| Constant
| Value
|
| xlAtBottom
| 2
|
| xlAtTop
| 1 |
XlTickLabelOrientation
| Constant
| Value
|
| xlTickLabelOrientationAutomatic
| -4105
|
| xlTickLabelOrientationDownward
| -4170
|
| xlTickLabelOrientationHorizontal
| -4128
|
| xlTickLabelOrientationUpward
| -4171
|
| xlTickLabelOrientationVertical
| -4166 |
XlTickLabelPosition
| Constant
| Value
|
| xlTickLabelPositionHigh
| -4127
|
| xlTickLabelPositionLow
| -4134
|
| xlTickLabelPositionNextToAxis
| 4
|
| xlTickLabelPositionNone
| -4142 |
XlTickMark
| Constant
| Value
|
| xlTickMarkCross
| 4
|
| xlTickMarkInside
| 2
|
| xlTickMarkNone
| -4142
|
| xlTickMarkOutside
| 3 |
XlTimeUnit
| Constant
| Value
|
| xlDays
| 0
|
| xlMonths
| 1
|
| xlYears
| 2 |
XlTrendlineType
| Constant
| Value
|
| xlExponential
| 5
|
| xlLinear
| -4132
|
| xlLogarithmic
| -4133
|
| xlMovingAvg
| 6
|
| xlPolynomial
| 3
|
| xlPower
| 4 |
XlUnderlineStyle
| Constant
| Value
|
| xlUnderlineStyleDouble
| -4119
|
| xlUnderlineStyleDoubleAccounting
| 5
|
| xlUnderlineStyleNone
| -4142
|
| xlUnderlineStyleSingle
| 2
|
| xlUnderlineStyleSingleAccounting
| 4 |
XlVAlign
| Constant
| Value
|
| xlVAlignBottom
| -4107
|
| xlVAlignCenter
| -4108
|
| xlVAlignDistributed
| -4117
|
| xlVAlignJustify
| -4130
|
| xlVAlignTop
| -4160 |
XlWebFormatting
| Constant
| Value
|
| xlWebFormattingAll
| 1
|
| xlWebFormattingNone
| 3
|
| xlWebFormattingRTF
| 2 |
XlWebSelectionType
| Constant
| Value
|
| xlAllTables
| 2
|
| xlEntirePage
| 1
|
| xlSpecifiedTables
| 3 |
XlWindowState
| Constant
| Value
|
| xlMaximized
| -4137
|
| xlMinimized
| -4140
|
| xlNormal
| -4143 |
XlWindowType
| Constant
| Value
|
| xlChartAsWindow
| 5
|
| xlChartInPlace
| 4
|
| xlClipboard
| 3
|
| xlInfo
| -4129
|
| xlWorkbook
| 1 |