This code puts a single point on my scatter plot. However the next 2 lines generate an error. How do you pass more than one X or Y value to the Set Data function in VBA?
These lines work:
Chart1_Series1.SetData OWC.ChartDimensionsEnum.chDimXValues, OWC.ChartSpecialDataSourcesEnum.chDataLiteral, (150)
Chart1_Series1.SetData OWC.ChartDimensionsEnum.chDimYValues, OWC.ChartSpecialDataSourcesEnum.chDataLiteral, (200)
These lines do not work: If I pass an array it give me an out of memory error.
Chart1_Series1.SetData OWC.ChartDimensionsEnum.chDimXValues, OWC.ChartSpecialDataSourcesEnum.chDataLiteral, (150,100)
Chart1_Series1.SetData OWC.ChartDimensionsEnum.chDimYValues, OWC.ChartSpecialDataSourcesEnum.chDataLiteral, (200,150)
Bookmarks