(Graph Visual Basic 参考) 的枚举

本主题提供 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 支持和反馈,获取有关如何接收支持和提供反馈的指南。