Hi

I am also working with MSGraph at the moment. I will try a post a form in the files section which changes various settings for your graph - form is called MyGraphOptions and is called thus

do form MyGraphOptions with thisform.oleMyGraph

It works and will give you an idea of how to manipulate the objects and collections of MSGraph.

Here is an include file for the constants
*-- msgraph.h
*-- Microsoft Graph defines for Microsoft Graph constants.

** Constants
#DEFINE xlAll -4104
#DEFINE xlAutomatic -4105
#DEFINE xlBoth 1
#DEFINE xlCenter -4108
#DEFINE xlChecker 9
#DEFINE xlCircle 8
#DEFINE xlCorner 2
#DEFINE xlCrissCross 16
#DEFINE xlCross 4
#DEFINE xlDiamond 2
#DEFINE xlDistributed -4117
#DEFINE xlDoubleAccounting 5
#DEFINE xlFixedValue 1
#DEFINE xlFormats -4122
#DEFINE xlGray16 17
#DEFINE xlGray8 18
#DEFINE xlGrid 15
#DEFINE xlHigh -4127
#DEFINE xlInside 2
#DEFINE xlJustify -4130
#DEFINE xlLightDown 13
#DEFINE xlLightHorizontal 11
#DEFINE xlLightUp 14
#DEFINE xlLightVertical 12
#DEFINE xlLow -4134
#DEFINE xlManual -4135
#DEFINE xlMinusValues 3
#DEFINE xlModule -4141
#DEFINE xlNextToAxis 4
#DEFINE xlNone -4142
#DEFINE xlNotes -4144
#DEFINE xlOff -4146
#DEFINE xlOn 1
#DEFINE xlPercent 2
#DEFINE xlPlus 9
#DEFINE xlPlusValues 2
#DEFINE xlSemiGray75 10
#DEFINE xlShowLabel 4
#DEFINE xlShowLabelAndPercent 5
#DEFINE xlShowPercent 3
#DEFINE xlShowValue 2
#DEFINE xlSimple -4154
#DEFINE xlSingle 2
#DEFINE xlSingleAccounting 4
#DEFINE xlSolid 1
#DEFINE xlSquare 1
#DEFINE xlStar 5
#DEFINE xlStError 4
#DEFINE xlToolbarButton 2
#DEFINE xlTriangle 3
#DEFINE xlGray25 -4124
#DEFINE xlGray50 -4125
#DEFINE xlGray75 -4126
#DEFINE xlBottom -4107
#DEFINE xlLeft -4131
#DEFINE xlRight -4152
#DEFINE xlTop -4160
#DEFINE xl3DBar -4099
#DEFINE xl3DSurface -4103
#DEFINE xlBar 2
#DEFINE xlColumn 3
#DEFINE xlCombination -4111
#DEFINE xlCustom -4114
#DEFINE xlDefaultAutoFormat -1
#DEFINE xlMaximum 2
#DEFINE xlMinimum 4
#DEFINE xlOpaque 3
#DEFINE xlTransparent 2
#DEFINE xlBidi -5000
#DEFINE xlLatin -5001
#DEFINE xlContext -5002
#DEFINE xlLTR -5003
#DEFINE xlRTL -5004
#DEFINE xlFullScript 1
#DEFINE xlPartialScript 2
#DEFINE xlMixedScript 3
#DEFINE xlMixedAuthorizedScript 4
#DEFINE xlDefault -4143
#DEFINE xlVisualCursor 2
#DEFINE xlLogicalCursor 1
#DEFINE xlSystem 1
#DEFINE xlPartial 3
#DEFINE xlHindiNumerals 3
#DEFINE xlBidiCalendar 3
#DEFINE xlGregorian 2
#DEFINE xlComplete 4
#DEFINE xlScale 3
#DEFINE xlWizardDisplayAlways 1
#DEFINE xlWizardDisplayDefault 0
#DEFINE xlWizardDisplayNever 2

** XlCreator
#DEFINE xlCreatorCode 1480803660

** XlChartGallery
#DEFINE xlBuiltIn 21
#DEFINE xlUserDefined 22
#DEFINE xlAnyGallery 23

** XlColorIndex
#DEFINE xlColorIndexAutomatic -4105
#DEFINE xlColorIndexNone -4142

** XlEndStyleCap
#DEFINE xlCap 1
#DEFINE xlNoCap 2

** XlRowCol
#DEFINE xlColumns 2
#DEFINE xlRows 1

** XlScaleType
#DEFINE xlScaleLinear -4132
#DEFINE xlScaleLogarithmic -4133

** XlDataSeriesType
#DEFINE xlAutoFill 4
#DEFINE xlChronological 3
#DEFINE xlGrowth 2
#DEFINE xlDataSeriesLinear -4132

** XlAxisCrosses
#DEFINE xlAxisCrossesAutomatic -4105
#DEFINE xlAxisCrossesCustom -4114
#DEFINE xlAxisCrossesMaximum 2
#DEFINE xlAxisCrossesMinimum 4

** XlAxisGroup
#DEFINE xlPrimary 1
#DEFINE xlSecondary 2

** XlBackground
#DEFINE xlBackgroundAutomatic -4105
#DEFINE xlBackgroundOpaque 3
#DEFINE xlBackgroundTransparent 2

** XlWindowState
#DEFINE xlMaximized -4137
#DEFINE xlMinimized -4140
#DEFINE xlNormal -4143

** XlAxisType
#DEFINE xlCategory 1
#DEFINE xlSeriesAxis 3
#DEFINE xlValue 2

** XlArrowHeadLength
#DEFINE xlArrowHeadLengthLong 3
#DEFINE xlArrowHeadLengthMedium -4138
#DEFINE xlArrowHeadLengthShort 1

** XlVAlign
#DEFINE xlVAlignBottom -4107
#DEFINE xlVAlignCenter -4108
#DEFINE xlVAlignDistributed -4117
#DEFINE xlVAlignJustify -4130
#DEFINE xlVAlignTop -4160

** XlTickMark
#DEFINE xlTickMarkCross 4
#DEFINE xlTickMarkInside 2
#DEFINE xlTickMarkNone -4142
#DEFINE xlTickMarkOutside 3

** XlErrorBarDirection
#DEFINE xlX -4168
#DEFINE xlY 1

** XlErrorBarInclude
#DEFINE xlErrorBarIncludeBoth 1
#DEFINE xlErrorBarIncludeMinusValues 3
#DEFINE xlErrorBarIncludeNone -4142
#DEFINE xlErrorBarIncludePlusValues 2

** XlDisplayBlanksAs
#DEFINE xlInterpolated 3
#DEFINE xlNotPlotted 1
#DEFINE xlZero 2

** XlArrowHeadStyle
#DEFINE xlArrowHeadStyleClosed 3
#DEFINE xlArrowHeadStyleDoubleClosed 5
#DEFINE xlArrowHeadStyleDoubleOpen 4
#DEFINE xlArrowHeadStyleNone -4142
#DEFINE xlArrowHeadStyleOpen 2

** XlArrowHeadWidth
#DEFINE xlArrowHeadWidthMedium -4138
#DEFINE xlArrowHeadWidthNarrow 1
#DEFINE xlArrowHeadWidthWide 3

** XlHAlign
#DEFINE xlHAlignCenter -4108
#DEFINE xlHAlignCenterAcrossSelection 7
#DEFINE xlHAlignDistributed -4117
#DEFINE xlHAlignFill 5
#DEFINE xlHAlignGeneral 1
#DEFINE xlHAlignJustify -4130
#DEFINE xlHAlignLeft -4131
#DEFINE xlHAlignRight -4152

** XlTickLabelPosition
#DEFINE xlTickLabelPositionHigh -4127
#DEFINE xlTickLabelPositionLow -4134
#DEFINE xlTickLabelPositionNextToAxis 4
#DEFINE xlTickLabelPositionNone -4142

** XlLegendPosition
#DEFINE xlLegendPositionBottom -4107
#DEFINE xlLegendPositionCorner 2
#DEFINE xlLegendPositionLeft -4131
#DEFINE xlLegendPositionRight -4152
#DEFINE xlLegendPositionTop -4160

** XlChartPictureType
#DEFINE xlStackScale 3
#DEFINE xlStack 2
#DEFINE xlStretch 1

** XlChartPicturePlacement
#DEFINE xlSides 1
#DEFINE xlEnd 2
#DEFINE xlEndSides 3
#DEFINE xlFront 4
#DEFINE xlFrontSides 5
#DEFINE xlFrontEnd 6
#DEFINE xlAllFaces 7

** XlOrientation
#DEFINE xlDownward -4170
#DEFINE xlHorizontal -4128
#DEFINE xlUpward -4171
#DEFINE xlVertical -4166

** XlTickLabelOrientation
#DEFINE xlTickLabelOrientationAutomatic -4105
#DEFINE xlTickLabelOrientationDownward -4170
#DEFINE xlTickLabelOrientationHorizontal -4128
#DEFINE xlTickLabelOrientationUpward -4171
#DEFINE xlTickLabelOrientationVertical -4166

** XlBorderWeight
#DEFINE xlHairline 1
#DEFINE xlMedium -4138
#DEFINE xlThick 4
#DEFINE xlThin 2

** XlDataSeriesDate
#DEFINE xlDay 1
#DEFINE xlMonth 3
#DEFINE xlWeekday 2
#DEFINE xlYear 4

** XlUnderlineStyle
#DEFINE xlUnderlineStyleDouble -4119
#DEFINE xlUnderlineStyleDoubleAccounting 5
#DEFINE xlUnderlineStyleNone -4142
#DEFINE xlUnderlineStyleSingle 2
#DEFINE xlUnderlineStyleSingleAccounting 4

** XlErrorBarType
#DEFINE xlErrorBarTypeCustom -4114
#DEFINE xlErrorBarTypeFixedValue 1
#DEFINE xlErrorBarTypePercent 2
#DEFINE xlErrorBarTypeStDev -4155
#DEFINE xlErrorBarTypeStError 4

** XlTrendlineType
#DEFINE xlExponential 5
#DEFINE xlLinear -4132
#DEFINE xlLogarithmic -4133
#DEFINE xlMovingAvg 6
#DEFINE xlPolynomial 3
#DEFINE xlPower 4

** XlLineStyle
#DEFINE xlContinuous 1
#DEFINE xlDash -4115
#DEFINE xlDashDot 4
#DEFINE xlDashDotDot 5
#DEFINE xlDot -4118
#DEFINE xlDouble -4119
#DEFINE xlSlantDashDot 13
#DEFINE xlLineStyleNone -4142

** XlDataLabelsType
#DEFINE xlDataLabelsShowNone -4142
#DEFINE xlDataLabelsShowValue 2
#DEFINE xlDataLabelsShowPercent 3
#DEFINE xlDataLabelsShowLabel 4
#DEFINE xlDataLabelsShowLabelAndPercent 5
#DEFINE xlDataLabelsShowBubbleSizes 6

** XlMarkerStyle
#DEFINE xlMarkerStyleAutomatic -4105
#DEFINE xlMarkerStyleCircle 8
#DEFINE xlMarkerStyleDash -4115
#DEFINE xlMarkerStyleDiamond 2
#DEFINE xlMarkerStyleDot -4118
#DEFINE xlMarkerStyleNone -4142
#DEFINE xlMarkerStylePicture -4147
#DEFINE xlMarkerStylePlus 9
#DEFINE xlMarkerStyleSquare 1
#DEFINE xlMarkerStyleStar 5
#DEFINE xlMarkerStyleTriangle 3
#DEFINE xlMarkerStyleX -4168

** XlPictureConvertorType
#DEFINE xlBMP 1
#DEFINE xlCGM 7
#DEFINE xlDRW 4
#DEFINE xlDXF 5
#DEFINE xlEPS 8
#DEFINE xlHGL 6
#DEFINE xlPCT 13
#DEFINE xlPCX 10
#DEFINE xlPIC 11
#DEFINE xlPLT 12
#DEFINE xlTIF 9
#DEFINE xlWMF 2
#DEFINE xlWPG 3

** XlPattern
#DEFINE xlPatternAutomatic -4105
#DEFINE xlPatternChecker 9
#DEFINE xlPatternCrissCross 16
#DEFINE xlPatternDown -4121
#DEFINE xlPatternGray16 17
#DEFINE xlPatternGray25 -4124
#DEFINE xlPatternGray50 -4125
#DEFINE xlPatternGray75 -4126
#DEFINE xlPatternGray8 18
#DEFINE xlPatternGrid 15
#DEFINE xlPatternHorizontal -4128
#DEFINE xlPatternLightDown 13
#DEFINE xlPatternLightHorizontal 11
#DEFINE xlPatternLightUp 14
#DEFINE xlPatternLightVertical 12
#DEFINE xlPatternNone -4142
#DEFINE xlPatternSemiGray75 10
#DEFINE xlPatternSolid 1
#DEFINE xlPatternUp -4162
#DEFINE xlPatternVertical -4166

** XlChartSplitType
#DEFINE xlSplitByPosition 1
#DEFINE xlSplitByPercentValue 3
#DEFINE xlSplitByCustomSplit 4
#DEFINE xlSplitByValue 2

** XlDisplayUnit
#DEFINE xlHundreds -2
#DEFINE xlThousands -3
#DEFINE xlTenThousands -4
#DEFINE xlHundredThousands -5
#DEFINE xlMillions -6
#DEFINE xlTenMillions -7
#DEFINE xlHundredMillions -8
#DEFINE xlThousandMillions -9
#DEFINE xlMillionMillions -10

** XlDataLabelPosition
#DEFINE xlLabelPositionCenter -4108
#DEFINE xlLabelPositionAbove 0
#DEFINE xlLabelPositionBelow 1
#DEFINE xlLabelPositionLeft -4131
#DEFINE xlLabelPositionRight -4152
#DEFINE xlLabelPositionOutsideEnd 2
#DEFINE xlLabelPositionInsideEnd 3
#DEFINE xlLabelPositionInsideBase 4
#DEFINE xlLabelPositionBestFit 5
#DEFINE xlLabelPositionMixed 6
#DEFINE xlLabelPositionCustom 7

** XlTimeUnit
#DEFINE xlDays 0
#DEFINE xlMonths 1
#DEFINE xlYears 2

** XlCategoryType
#DEFINE xlCategoryScale 2
#DEFINE xlTimeScale 3
#DEFINE xlAutomaticScale -4105

** XlBarShape
#DEFINE xlBox 0
#DEFINE xlPyramidToPoint 1
#DEFINE xlPyramidToMax 2
#DEFINE xlCylinder 3
#DEFINE xlConeToPoint 4
#DEFINE xlConeToMax 5

** XlChartType
#DEFINE xlColumnClustered 51
#DEFINE xlColumnStacked 52
#DEFINE xlColumnStacked100 53
#DEFINE xl3DColumnClustered 54
#DEFINE xl3DColumnStacked 55
#DEFINE xl3DColumnStacked100 56
#DEFINE xlBarClustered 57
#DEFINE xlBarStacked 58
#DEFINE xlBarStacked100 59
#DEFINE xl3DBarClustered 60
#DEFINE xl3DBarStacked 61
#DEFINE xl3DBarStacked100 62
#DEFINE xlLineStacked 63
#DEFINE xlLineStacked100 64
#DEFINE xlLineMarkers 65
#DEFINE xlLineMarkersStacked 66
#DEFINE xlLineMarkersStacked100 67
#DEFINE xlPieOfPie 68
#DEFINE xlPieExploded 69
#DEFINE xl3DPieExploded 70
#DEFINE xlBarOfPie 71
#DEFINE xlXYScatterSmooth 72
#DEFINE xlXYScatterSmoothNoMarkers 73
#DEFINE xlXYScatterLines 74
#DEFINE xlXYScatterLinesNoMarkers 75
#DEFINE xlAreaStacked 76
#DEFINE xlAreaStacked100 77
#DEFINE xl3DAreaStacked 78
#DEFINE xl3DAreaStacked100 79
#DEFINE xlDoughnutExploded 80
#DEFINE xlRadarMarkers 81
#DEFINE xlRadarFilled 82
#DEFINE xlSurface 83
#DEFINE xlSurfaceWireframe 84
#DEFINE xlSurfaceTopView 85
#DEFINE xlSurfaceTopViewWireframe 86
#DEFINE xlBubble 15
#DEFINE xlBubble3DEffect 87
#DEFINE xlStockHLC 88
#DEFINE xlStockOHLC 89
#DEFINE xlStockVHLC 90
#DEFINE xlStockVOHLC 91
#DEFINE xlCylinderColClustered 92
#DEFINE xlCylinderColStacked 93
#DEFINE xlCylinderColStacked100 94
#DEFINE xlCylinderBarClustered 95
#DEFINE xlCylinderBarStacked 96
#DEFINE xlCylinderBarStacked100 97
#DEFINE xlCylinderCol 98
#DEFINE xlConeColClustered 99
#DEFINE xlConeColStacked 100
#DEFINE xlConeColStacked100 101
#DEFINE xlConeBarClustered 102
#DEFINE xlConeBarStacked 103
#DEFINE xlConeBarStacked100 104
#DEFINE xlConeCol 105
#DEFINE xlPyramidColClustered 106
#DEFINE xlPyramidColStacked 107
#DEFINE xlPyramidColStacked100 108
#DEFINE xlPyramidBarClustered 109
#DEFINE xlPyramidBarStacked 110
#DEFINE xlPyramidBarStacked100 111
#DEFINE xlPyramidCol 112
#DEFINE xl3DColumn -4100
#DEFINE xlLine 4
#DEFINE xl3DLine -4101
#DEFINE xl3DPie -4102
#DEFINE xlPie 5
#DEFINE xlXYScatter -4169
#DEFINE xl3DArea -4098
#DEFINE xlArea 1
#DEFINE xlDoughnut -4120
#DEFINE xlRadar -4151

** XlChartItem
#DEFINE xlDataLabel 0
#DEFINE xlChartArea 2
#DEFINE xlSeries 3
#DEFINE xlChartTitle 4
#DEFINE xlWalls 5
#DEFINE xlCorners 6
#DEFINE xlDataTable 7
#DEFINE xlTrendline 8
#DEFINE xlErrorBars 9
#DEFINE xlXErrorBars 10
#DEFINE xlYErrorBars 11
#DEFINE xlLegendEntry 12
#DEFINE xlLegendKey 13
#DEFINE xlShape 14
#DEFINE xlMajorGridlines 15
#DEFINE xlMinorGridlines 16
#DEFINE xlAxisTitle 17
#DEFINE xlUpBars 18
#DEFINE xlPlotArea 19
#DEFINE xlDownBars 20
#DEFINE xlAxis 21
#DEFINE xlSeriesLines 22
#DEFINE xlFloor 23
#DEFINE xlLegend 24
#DEFINE xlHiLoLines 25
#DEFINE xlDropLines 26
#DEFINE xlRadarAxisLabels 27
#DEFINE xlNothing 28
#DEFINE xlLeaderLines 29
#DEFINE xlDisplayUnitLabel 30
#DEFINE xlPivotChartFieldButton 31
#DEFINE xlPivotChartDropZone 32

** XlSizeRepresents
#DEFINE xlSizeIsWidth 2
#DEFINE xlSizeIsArea 1

** XlInsertShiftDirection
#DEFINE xlShiftDown -4121
#DEFINE xlShiftToRight -4161

** XlDeleteShiftDirection
#DEFINE xlShiftToLeft -4159
#DEFINE xlShiftUp -4162

** XlDirection
#DEFINE xlDown -4121
#DEFINE xlToLeft -4159
#DEFINE xlToRight -4161
#DEFINE xlUp -4162

** XlConsolidationFunction
#DEFINE xlAverage -4106
#DEFINE xlCount -4112
#DEFINE xlCountNums -4113
#DEFINE xlMax -4136
#DEFINE xlMin -4139
#DEFINE xlProduct -4149
#DEFINE xlStDev -4155
#DEFINE xlStDevP -4156
#DEFINE xlSum -4157
#DEFINE xlVar -4164
#DEFINE xlVarP -4165
#DEFINE xlUnknown 1000

** XlSheetType
#DEFINE xlChart -4109
#DEFINE xlDialogSheet -4116
#DEFINE xlExcel4IntlMacroSheet 4
#DEFINE xlExcel4MacroSheet 3
#DEFINE xlWorksheet -4167

** XlLocationInTable
#DEFINE xlColumnHeader -4110
#DEFINE xlColumnItem 5
#DEFINE xlDataHeader 3
#DEFINE xlDataItem 7
#DEFINE xlPageHeader 2
#DEFINE xlPageItem 6
#DEFINE xlRowHeader -4153
#DEFINE xlRowItem 4
#DEFINE xlTableBody 8

** XlFindLookIn
#DEFINE xlFormulas -4123
#DEFINE xlComments -4144
#DEFINE xlValues -4163

** XlWindowType
#DEFINE xlChartAsWindow 5
#DEFINE xlChartInPlace 4
#DEFINE xlClipboard 3
#DEFINE xlInfo -4129
#DEFINE xlWorkbook 1

** XlPivotFieldDataType
#DEFINE xlDate 2
#DEFINE xlNumber -4145
#DEFINE xlText -4158

** XlCopyPictureFormat
#DEFINE xlBitmap 2
#DEFINE xlPicture -4147

** XlPivotTableSourceType
#DEFINE xlConsolidation 3
#DEFINE xlDatabase 1
#DEFINE xlExternal 2
#DEFINE xlPivotTable -4148

** XlReferenceStyle
#DEFINE xlA1 1
#DEFINE xlR1C1 -4150

** xlPivotFormatType
#DEFINE xlReport1 0
#DEFINE xlReport2 1
#DEFINE xlReport3 2
#DEFINE xlReport4 3
#DEFINE xlReport5 4
#DEFINE xlReport6 5
#DEFINE xlReport7 6
#DEFINE xlReport8 7
#DEFINE xlReport9 8
#DEFINE xlReport10 9
#DEFINE xlTable1 10
#DEFINE xlTable2 11
#DEFINE xlTable3 12
#DEFINE xlTable4 13
#DEFINE xlTable5 14
#DEFINE xlTable6 15
#DEFINE xlTable7 16
#DEFINE xlTable8 17
#DEFINE xlTable9 18
#DEFINE xlTable10 19
#DEFINE xlPTClassic 20
#DEFINE xlPTNone 21

** XlCmdType
#DEFINE xlCmdCube 1
#DEFINE xlCmdSql 2
#DEFINE xlCmdTable 3
#DEFINE xlCmdDefault 4


** xlColumnDataType
#DEFINE xlGeneralFormat 1
#DEFINE xlTextFormat 2
#DEFINE xlMDYFormat 3
#DEFINE xlDMYFormat 4
#DEFINE xlYMDFormat 5
#DEFINE xlMYDFormat 6
#DEFINE xlDYMFormat 7
#DEFINE xlYDMFormat 8
#DEFINE xlSkipColumn 9
#DEFINE xlEMDFormat 10

** xlQueryType
#DEFINE xlODBCQuery 1
#DEFINE xlDAORecordSet 2
#DEFINE xlWebQuery 4
#DEFINE xlOLEDBQuery 5
#DEFINE xlTextImport 6
#DEFINE xlADORecordset 7

** xlWebSelectionType
#DEFINE xlEntirePage 1
#DEFINE xlAllTables 2
#DEFINE xlSpecifiedTables 3

** XlCubeFieldType
#DEFINE xlHierarchy 1
#DEFINE xlMeasure 2

** xlWebFormatting
#DEFINE xlWebFormattingAll 1
#DEFINE xlWebFormattingRTF 2
#DEFINE xlWebFormattingNone 3

** xlDisplayDrawingObjects
#DEFINE xlDisplayShapes -4104
#DEFINE xlHide 3
#DEFINE xlPlaceholders 2

** xLSubtototalLocationType
#DEFINE xlAtTop 1
#DEFINE xlAtBottom 2

**EOF


Cheers
Charlie