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

名稱 值
xlHundred並排 -8
xlHundreds -2
xlHundredThousands -5
xl][圖表][圖表] -10
xl並排 -6
xlTen並排 -7
xlTenThousands -4
xlThousand並排 -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 支援與意見反應。