I have a query in SQL and I want to add the data of the query to an MSGRAPH 8.0 object using code. So far, I have been able to select with code the type of chart as well as adding the the title of both AXIS and the main title of the chart. However, I still need to add the chart ROW LABELS and COLUMN LABELS of the chart, as well as adding the data of my query.
Thanks in advance
'type of chart
MGO1.chartType = xlLine
'sets the legend of the chart on
MGO1.HasLegend = True
'sets the main title of the chart
MGO1.HasTitle = True
MGO1.ChartTitle.Text = "ANOMALÍAS"
'Set the Y axis title
MGO1.Axes(xlValue).HasTitle = True
MGO1.Axes(xlValue).AxisTitle.Caption = "Porcentajes"
'sets the X axis title
MGO1.Axes(xlCategory).HasTitle = True
MGO1.Axes(xlCategory).AxisTitle.Caption = "Periodos"