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