Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |
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.