how to add RegressionCurves to Chart using BASIC

users
#1

I found how to add regression curves using Java, can it been done using Basic ?
if found no methods to add first a RegressionCurveContainer
and to add a RegressionCurve to this container ?

Thanks for any hint

XDataSeries[] dataSeriesArr = getDataSeries(chartDoc);

     XRegressionCurveContainer rcCon = UnoRuntime.queryInterface( XRegressionCurveContainer.class, dataSeriesArr[0]);

     XRegressionCurve[] curves = rcCon.getRegressionCurves();

     XRegressionCurve curve = Lo.createInstanceMCF(XRegressionCurve.class, "com.sun.star.chart2.LinearRegressionCurve"); // for a linear regression curve
     rcCon.addRegressionCurve(curve);

#2

ok: found it myself
the clue is to add a curve to a dataserie

     oDoc = StarDesktop.LoadComponentFromUrl("private:factory/scalc","_default",0,loadArgs())
     oSheet = oDoc.Sheets.getByIndex(0)

      oCharts = osheet.charts
      If IsMissing(ChartNum) Then ChartNum=0
          With oRect
              .X = 0
              .Y = YPos

                .Height= 12000
                .width = 12000/4 * ubound(LabelsArray())
          End With
' Remove the CName
'chart if it exists
      If oSheet.getCharts().hasByName(CName) Then
         oSheet.getCharts().removeByName(CName)
      endif
     ' Make Chart
      oCharts.addNewByName(CName,oRect,Array(),TRUE, TRUE)
      oChart = oCharts.getByName(CName).embeddedObject
      oChart.diagram = oChart.createInstance("com.sun.star.chart.AreaDiagram")
      oDiagram = ochart.getFirstDiagram()
     oCoords = oDiagram.getCoordinateSystems()
     oCoord = oCoords(0)
     oChartTypes = oCoord.getChartTypes()
     oChartType = oChartTypes(0)
     oNewDataSeries = CreateUnoService("com.sun.star.chart2.DataSeries")
     oChartType.addDataSeries(oNewDataSeries)
     oDataSeriesList = oChartType.getDataSeries()
     oMyDataSerie= oDataSeriesList(0)'=' first series
'creating curve
     oMyCurve = CreateUnoService("com.sun.star.chart2.PolynomialRegressionCurve")
'add curve to DataSerie
     oMyDataSerie.addregressioncurve(oMycurve)

     oChart.lockControllers()
' Data
      oChart.Data.setData(ChartDataArray())

#3

Hi :slight_smile:
WOW!! Superb! :)) Congrats on figuring that out!

Also many thanks for posting the answer back to the mailing list so that;
1. other people don't spend time trying to figure it out
2. if someone has the same problem in the future then they might be able
to find it in the archives, or one of us might remember.

So congrats, many thanks and regards from
Tom :slight_smile: