Graph, COM interface constants for VB.Net / VBScript
Graph - interface constants
This page contains simple VBA include for the Graph COM library.
library parameters| File Name | Program Files\Microsoft Office\OFFICE11\GRAPH.EXE |
|---|
| Guid | {00020802-0000-0000-C000-000000000046} |
|---|
| Enums | 75 |
|---|
Constantsenum, 90 members.Public Enum Constants
xlAll = -4104
xlAutomatic = -4105
xlBoth = 1
xlCenter = -4108
xlChecker = 9
xlCircle = 8
xlCorner = 2
xlCrissCross = 16
xlCross = 4
xlDiamond = 2
xlDistributed = -4117
xlDoubleAccounting = 5
xlFixedValue = 1
xlFormats = -4122
xlGray16 = 17
xlGray8 = 18
xlGrid = 15
xlHigh = -4127
xlInside = 2
xlJustify = -4130
xlLightDown = 13
xlLightHorizontal = 11
xlLightUp = 14
xlLightVertical = 12
xlLow = -4134
xlManual = -4135
xlMinusValues = 3
xlModule = -4141
xlNextToAxis = 4
xlNone = -4142
xlNotes = -4144
xlOff = -4146
xlOn = 1
xlPercent = 2
xlPlus = 9
xlPlusValues = 2
xlSemiGray75 = 10
xlShowLabel = 4
xlShowLabelAndPercent = 5
xlShowPercent = 3
xlShowValue = 2
xlSimple = -4154
xlSingle = 2
xlSingleAccounting = 4
xlSolid = 1
xlSquare = 1
xlStar = 5
xlStError = 4
xlToolbarButton = 2
xlTriangle = 3
xlGray25 = -4124
xlGray50 = -4125
xlGray75 = -4126
xlBottom = -4107
xlLeft = -4131
xlRight = -4152
xlTop = -4160
xl3DBar = -4099
xl3DSurface = -4103
xlBar = 2
xlColumn = 3
xlCombination = -4111
xlCustom = -4114
xlDefaultAutoFormat = -1
xlMaximum = 2
xlMinimum = 4
xlOpaque = 3
xlTransparent = 2
xlBidi = -5000
xlLatin = -5001
xlContext = -5002
xlLTR = -5003
xlRTL = -5004
xlFullScript = 1
xlPartialScript = 2
xlMixedScript = 3
xlMixedAuthorizedScript = 4
xlDefault = -4143
xlVisualCursor = 2
xlLogicalCursor = 1
xlSystem = 1
xlPartial = 3
xlHindiNumerals = 3
xlBidiCalendar = 3
xlGregorian = 2
xlComplete = 4
xlScale = 3
xlWizardDisplayAlways = 1
xlWizardDisplayDefault = 0
xlWizardDisplayNever = 2
End Enum
XlCreatorenum, 1 members.Public Enum XlCreator
xlCreatorCode = 1480803660
End Enum
XlChartGalleryenum, 3 members.Public Enum XlChartGallery
xlBuiltIn = 21
xlUserDefined = 22
xlAnyGallery = 23
End Enum
XlColorIndexenum, 2 members.Public Enum XlColorIndex
xlColorIndexAutomatic = -4105
xlColorIndexNone = -4142
End Enum
XlEndStyleCapenum, 2 members.Public Enum XlEndStyleCap
xlCap = 1
xlNoCap = 2
End Enum
XlRowColenum, 2 members.Public Enum XlRowCol
xlColumns = 2
xlRows = 1
End Enum
XlScaleTypeenum, 2 members.Public Enum XlScaleType
xlScaleLinear = -4132
xlScaleLogarithmic = -4133
End Enum
XlDataSeriesTypeenum, 4 members.Public Enum XlDataSeriesType
xlAutoFill = 4
xlChronological = 3
xlGrowth = 2
xlDataSeriesLinear = -4132
End Enum
XlAxisCrossesenum, 4 members.Public Enum XlAxisCrosses
xlAxisCrossesAutomatic = -4105
xlAxisCrossesCustom = -4114
xlAxisCrossesMaximum = 2
xlAxisCrossesMinimum = 4
End Enum
XlAxisGroupenum, 2 members.Public Enum XlAxisGroup
xlPrimary = 1
xlSecondary = 2
End Enum
XlBackgroundenum, 3 members.Public Enum XlBackground
xlBackgroundAutomatic = -4105
xlBackgroundOpaque = 3
xlBackgroundTransparent = 2
End Enum
XlWindowStateenum, 3 members.Public Enum XlWindowState
xlMaximized = -4137
xlMinimized = -4140
xlNormal = -4143
End Enum
XlAxisTypeenum, 3 members.Public Enum XlAxisType
xlCategory = 1
xlSeriesAxis = 3
xlValue = 2
End Enum
XlArrowHeadLengthenum, 3 members.Public Enum XlArrowHeadLength
xlArrowHeadLengthLong = 3
xlArrowHeadLengthMedium = -4138
xlArrowHeadLengthShort = 1
End Enum
XlVAlignenum, 5 members.Public Enum XlVAlign
xlVAlignBottom = -4107
xlVAlignCenter = -4108
xlVAlignDistributed = -4117
xlVAlignJustify = -4130
xlVAlignTop = -4160
End Enum
XlTickMarkenum, 4 members.Public Enum XlTickMark
xlTickMarkCross = 4
xlTickMarkInside = 2
xlTickMarkNone = -4142
xlTickMarkOutside = 3
End Enum
XlErrorBarDirectionenum, 2 members.Public Enum XlErrorBarDirection
xlX = -4168
xlY = 1
End Enum
XlErrorBarIncludeenum, 4 members.Public Enum XlErrorBarInclude
xlErrorBarIncludeBoth = 1
xlErrorBarIncludeMinusValues = 3
xlErrorBarIncludeNone = -4142
xlErrorBarIncludePlusValues = 2
End Enum
XlDisplayBlanksAsenum, 3 members.Public Enum XlDisplayBlanksAs
xlInterpolated = 3
xlNotPlotted = 1
xlZero = 2
End Enum
XlArrowHeadStyleenum, 5 members.Public Enum XlArrowHeadStyle
xlArrowHeadStyleClosed = 3
xlArrowHeadStyleDoubleClosed = 5
xlArrowHeadStyleDoubleOpen = 4
xlArrowHeadStyleNone = -4142
xlArrowHeadStyleOpen = 2
End Enum
XlArrowHeadWidthenum, 3 members.Public Enum XlArrowHeadWidth
xlArrowHeadWidthMedium = -4138
xlArrowHeadWidthNarrow = 1
xlArrowHeadWidthWide = 3
End Enum
XlHAlignenum, 8 members.Public Enum XlHAlign
xlHAlignCenter = -4108
xlHAlignCenterAcrossSelection = 7
xlHAlignDistributed = -4117
xlHAlignFill = 5
xlHAlignGeneral = 1
xlHAlignJustify = -4130
xlHAlignLeft = -4131
xlHAlignRight = -4152
End Enum
XlTickLabelPositionenum, 4 members.Public Enum XlTickLabelPosition
xlTickLabelPositionHigh = -4127
xlTickLabelPositionLow = -4134
xlTickLabelPositionNextToAxis = 4
xlTickLabelPositionNone = -4142
End Enum
XlLegendPositionenum, 5 members.Public Enum XlLegendPosition
xlLegendPositionBottom = -4107
xlLegendPositionCorner = 2
xlLegendPositionLeft = -4131
xlLegendPositionRight = -4152
xlLegendPositionTop = -4160
End Enum
XlChartPictureTypeenum, 3 members.Public Enum XlChartPictureType
xlStackScale = 3
xlStack = 2
xlStretch = 1
End Enum
XlChartPicturePlacementenum, 7 members.Public Enum XlChartPicturePlacement
xlSides = 1
xlEnd = 2
xlEndSides = 3
xlFront = 4
xlFrontSides = 5
xlFrontEnd = 6
xlAllFaces = 7
End Enum
XlOrientationenum, 4 members.Public Enum XlOrientation
xlDownward = -4170
xlHorizontal = -4128
xlUpward = -4171
xlVertical = -4166
End Enum
XlTickLabelOrientationenum, 5 members.Public Enum XlTickLabelOrientation
xlTickLabelOrientationAutomatic = -4105
xlTickLabelOrientationDownward = -4170
xlTickLabelOrientationHorizontal = -4128
xlTickLabelOrientationUpward = -4171
xlTickLabelOrientationVertical = -4166
End Enum
XlBorderWeightenum, 4 members.Public Enum XlBorderWeight
xlHairline = 1
xlMedium = -4138
xlThick = 4
xlThin = 2
End Enum
XlDataSeriesDateenum, 4 members.Public Enum XlDataSeriesDate
xlDay = 1
xlMonth = 3
xlWeekday = 2
xlYear = 4
End Enum
XlUnderlineStyleenum, 5 members.Public Enum XlUnderlineStyle
xlUnderlineStyleDouble = -4119
xlUnderlineStyleDoubleAccounting = 5
xlUnderlineStyleNone = -4142
xlUnderlineStyleSingle = 2
xlUnderlineStyleSingleAccounting = 4
End Enum
XlErrorBarTypeenum, 5 members.Public Enum XlErrorBarType
xlErrorBarTypeCustom = -4114
xlErrorBarTypeFixedValue = 1
xlErrorBarTypePercent = 2
xlErrorBarTypeStDev = -4155
xlErrorBarTypeStError = 4
End Enum
XlTrendlineTypeenum, 6 members.Public Enum XlTrendlineType
xlExponential = 5
xlLinear = -4132
xlLogarithmic = -4133
xlMovingAvg = 6
xlPolynomial = 3
xlPower = 4
End Enum
XlLineStyleenum, 8 members.Public Enum XlLineStyle
xlContinuous = 1
xlDash = -4115
xlDashDot = 4
xlDashDotDot = 5
xlDot = -4118
xlDouble = -4119
xlSlantDashDot = 13
xlLineStyleNone = -4142
End Enum
XlDataLabelsTypeenum, 6 members.Public Enum XlDataLabelsType
xlDataLabelsShowNone = -4142
xlDataLabelsShowValue = 2
xlDataLabelsShowPercent = 3
xlDataLabelsShowLabel = 4
xlDataLabelsShowLabelAndPercent = 5
xlDataLabelsShowBubbleSizes = 6
End Enum
XlMarkerStyleenum, 12 members.Public Enum 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
End Enum
XlPictureConvertorTypeenum, 13 members.Public Enum 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
End Enum
XlPatternenum, 20 members.Public Enum 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
End Enum
XlChartSplitTypeenum, 4 members.Public Enum XlChartSplitType
xlSplitByPosition = 1
xlSplitByPercentValue = 3
xlSplitByCustomSplit = 4
xlSplitByValue = 2
End Enum
XlDisplayUnitenum, 9 members.Public Enum XlDisplayUnit
xlHundreds = -2
xlThousands = -3
xlTenThousands = -4
xlHundredThousands = -5
xlMillions = -6
xlTenMillions = -7
xlHundredMillions = -8
xlThousandMillions = -9
xlMillionMillions = -10
End Enum
XlDataLabelPositionenum, 11 members.Public Enum XlDataLabelPosition
xlLabelPositionCenter = -4108
xlLabelPositionAbove = 0
xlLabelPositionBelow = 1
xlLabelPositionLeft = -4131
xlLabelPositionRight = -4152
xlLabelPositionOutsideEnd = 2
xlLabelPositionInsideEnd = 3
xlLabelPositionInsideBase = 4
xlLabelPositionBestFit = 5
xlLabelPositionMixed = 6
xlLabelPositionCustom = 7
End Enum
XlTimeUnitenum, 3 members.Public Enum XlTimeUnit
xlDays = 0
xlMonths = 1
xlYears = 2
End Enum
XlCategoryTypeenum, 3 members.Public Enum XlCategoryType
xlCategoryScale = 2
xlTimeScale = 3
xlAutomaticScale = -4105
End Enum
XlBarShapeenum, 6 members.Public Enum XlBarShape
xlBox = 0
xlPyramidToPoint = 1
xlPyramidToMax = 2
xlCylinder = 3
xlConeToPoint = 4
xlConeToMax = 5
End Enum
XlChartTypeenum, 73 members.Public Enum XlChartType
xlColumnClustered = 51
xlColumnStacked = 52
xlColumnStacked100 = 53
xl3DColumnClustered = 54
xl3DColumnStacked = 55
xl3DColumnStacked100 = 56
xlBarClustered = 57
xlBarStacked = 58
xlBarStacked100 = 59
xl3DBarClustered = 60
xl3DBarStacked = 61
xl3DBarStacked100 = 62
xlLineStacked = 63
xlLineStacked100 = 64
xlLineMarkers = 65
xlLineMarkersStacked = 66
xlLineMarkersStacked100 = 67
xlPieOfPie = 68
xlPieExploded = 69
xl3DPieExploded = 70
xlBarOfPie = 71
xlXYScatterSmooth = 72
xlXYScatterSmoothNoMarkers = 73
xlXYScatterLines = 74
xlXYScatterLinesNoMarkers = 75
xlAreaStacked = 76
xlAreaStacked100 = 77
xl3DAreaStacked = 78
xl3DAreaStacked100 = 79
xlDoughnutExploded = 80
xlRadarMarkers = 81
xlRadarFilled = 82
xlSurface = 83
xlSurfaceWireframe = 84
xlSurfaceTopView = 85
xlSurfaceTopViewWireframe = 86
xlBubble = 15
xlBubble3DEffect = 87
xlStockHLC = 88
xlStockOHLC = 89
xlStockVHLC = 90
xlStockVOHLC = 91
xlCylinderColClustered = 92
xlCylinderColStacked = 93
xlCylinderColStacked100 = 94
xlCylinderBarClustered = 95
xlCylinderBarStacked = 96
xlCylinderBarStacked100 = 97
xlCylinderCol = 98
xlConeColClustered = 99
xlConeColStacked = 100
xlConeColStacked100 = 101
xlConeBarClustered = 102
xlConeBarStacked = 103
xlConeBarStacked100 = 104
xlConeCol = 105
xlPyramidColClustered = 106
xlPyramidColStacked = 107
xlPyramidColStacked100 = 108
xlPyramidBarClustered = 109
xlPyramidBarStacked = 110
xlPyramidBarStacked100 = 111
xlPyramidCol = 112
xl3DColumn = -4100
xlLine = 4
xl3DLine = -4101
xl3DPie = -4102
xlPie = 5
xlXYScatter = -4169
xl3DArea = -4098
xlArea = 1
xlDoughnut = -4120
xlRadar = -4151
End Enum
XlChartItemenum, 32 members.Public Enum XlChartItem
xlDataLabel = 0
xlChartArea = 2
xlSeries = 3
xlChartTitle = 4
xlWalls = 5
xlCorners = 6
xlDataTable = 7
xlTrendline = 8
xlErrorBars = 9
xlXErrorBars = 10
xlYErrorBars = 11
xlLegendEntry = 12
xlLegendKey = 13
xlShape = 14
xlMajorGridlines = 15
xlMinorGridlines = 16
xlAxisTitle = 17
xlUpBars = 18
xlPlotArea = 19
xlDownBars = 20
xlAxis = 21
xlSeriesLines = 22
xlFloor = 23
xlLegend = 24
xlHiLoLines = 25
xlDropLines = 26
xlRadarAxisLabels = 27
xlNothing = 28
xlLeaderLines = 29
xlDisplayUnitLabel = 30
xlPivotChartFieldButton = 31
xlPivotChartDropZone = 32
End Enum
XlSizeRepresentsenum, 2 members.Public Enum XlSizeRepresents
xlSizeIsWidth = 2
xlSizeIsArea = 1
End Enum
XlInsertShiftDirectionenum, 2 members.Public Enum XlInsertShiftDirection
xlShiftDown = -4121
xlShiftToRight = -4161
End Enum
XlDeleteShiftDirectionenum, 2 members.Public Enum XlDeleteShiftDirection
xlShiftToLeft = -4159
xlShiftUp = -4162
End Enum
XlDirectionenum, 4 members.Public Enum XlDirection
xlDown = -4121
xlToLeft = -4159
xlToRight = -4161
xlUp = -4162
End Enum
XlConsolidationFunctionenum, 12 members.Public Enum XlConsolidationFunction
xlAverage = -4106
xlCount = -4112
xlCountNums = -4113
xlMax = -4136
xlMin = -4139
xlProduct = -4149
xlStDev = -4155
xlStDevP = -4156
xlSum = -4157
xlVar = -4164
xlVarP = -4165
xlUnknown = 1000
End Enum
XlSheetTypeenum, 5 members.Public Enum XlSheetType
xlChart = -4109
xlDialogSheet = -4116
xlExcel4IntlMacroSheet = 4
xlExcel4MacroSheet = 3
xlWorksheet = -4167
End Enum
XlLocationInTableenum, 9 members.Public Enum XlLocationInTable
xlColumnHeader = -4110
xlColumnItem = 5
xlDataHeader = 3
xlDataItem = 7
xlPageHeader = 2
xlPageItem = 6
xlRowHeader = -4153
xlRowItem = 4
xlTableBody = 8
End Enum
XlFindLookInenum, 3 members.Public Enum XlFindLookIn
xlFormulas = -4123
xlComments = -4144
xlValues = -4163
End Enum
XlWindowTypeenum, 5 members.Public Enum XlWindowType
xlChartAsWindow = 5
xlChartInPlace = 4
xlClipboard = 3
xlInfo = -4129
xlWorkbook = 1
End Enum
XlPivotFieldDataTypeenum, 3 members.Public Enum XlPivotFieldDataType
xlDate = 2
xlNumber = -4145
xlText = -4158
End Enum
XlCopyPictureFormatenum, 2 members.Public Enum XlCopyPictureFormat
xlBitmap = 2
xlPicture = -4147
End Enum
XlPivotTableSourceTypeenum, 5 members.Public Enum XlPivotTableSourceType
xlScenario = 4
xlConsolidation = 3
xlDatabase = 1
xlExternal = 2
xlPivotTable = -4148
End Enum
XlReferenceStyleenum, 2 members.Public Enum XlReferenceStyle
xlA1 = 1
xlR1C1 = -4150
End Enum
XlPivotFormatTypeenum, 22 members.Public Enum XlPivotFormatType
xlReport1 = 0
xlReport2 = 1
xlReport3 = 2
xlReport4 = 3
xlReport5 = 4
xlReport6 = 5
xlReport7 = 6
xlReport8 = 7
xlReport9 = 8
xlReport10 = 9
xlTable1 = 10
xlTable2 = 11
xlTable3 = 12
xlTable4 = 13
xlTable5 = 14
xlTable6 = 15
xlTable7 = 16
xlTable8 = 17
xlTable9 = 18
xlTable10 = 19
xlPTClassic = 20
xlPTNone = 21
End Enum
XlCmdTypeenum, 4 members.Public Enum XlCmdType
xlCmdCube = 1
xlCmdSql = 2
xlCmdTable = 3
xlCmdDefault = 4
End Enum
XlColumnDataTypeenum, 10 members.Public Enum XlColumnDataType
xlGeneralFormat = 1
xlTextFormat = 2
xlMDYFormat = 3
xlDMYFormat = 4
xlYMDFormat = 5
xlMYDFormat = 6
xlDYMFormat = 7
xlYDMFormat = 8
xlSkipColumn = 9
xlEMDFormat = 10
End Enum
XlQueryTypeenum, 6 members.Public Enum XlQueryType
xlODBCQuery = 1
xlDAORecordset = 2
xlWebQuery = 4
xlOLEDBQuery = 5
xlTextImport = 6
xlADORecordset = 7
End Enum
XlWebSelectionTypeenum, 3 members.Public Enum XlWebSelectionType
xlEntirePage = 1
xlAllTables = 2
xlSpecifiedTables = 3
End Enum
XlCubeFieldTypeenum, 3 members.Public Enum XlCubeFieldType
xlHierarchy = 1
xlMeasure = 2
xlSet = 3
End Enum
XlWebFormattingenum, 3 members.Public Enum XlWebFormatting
xlWebFormattingAll = 1
xlWebFormattingRTF = 2
xlWebFormattingNone = 3
End Enum
XlDisplayDrawingObjectsenum, 3 members.Public Enum XlDisplayDrawingObjects
xlDisplayShapes = -4104
xlHide = 3
xlPlaceholders = 2
End Enum
XlSubtototalLocationTypeenum, 2 members.Public Enum XlSubtototalLocationType
xlAtTop = 1
xlAtBottom = 2
End Enum
XlDataLabelSeparatorenum, 1 members.Public Enum XlDataLabelSeparator
xlDataLabelSeparatorDefault = 1
End Enum
XlRangeValueDataTypeenum, 3 members.Public Enum XlRangeValueDataType
xlRangeValueDefault = 10
xlRangeValueXMLSpreadsheet = 11
xlRangeValueMSPersistXML = 12
End Enum
XlInsertFormatOriginenum, 2 members.Public Enum XlInsertFormatOrigin
xlFormatFromLeftOrAbove = 0
xlFormatFromRightOrBelow = 1
End Enum
XlArabicModesenum, 4 members.Public Enum XlArabicModes
xlArabicNone = 0
xlArabicStrictAlefHamza = 1
xlArabicStrictFinalYaa = 2
xlArabicBothStrict = 3
End Enum
XlImportDataAsenum, 2 members.Public Enum XlImportDataAs
xlQueryTable = 0
xlPivotTableReport = 1
End Enum
XlCalculatedMemberTypeenum, 2 members.Public Enum XlCalculatedMemberType
xlCalculatedMember = 0
xlCalculatedSet = 1
End Enum
XlHebrewModesenum, 4 members.Public Enum XlHebrewModes
xlHebrewFullScript = 0
xlHebrewPartialScript = 1
xlHebrewMixedScript = 2
xlHebrewMixedAuthorizedScript = 3
End Enum
|