when using Me.MSChart1.ChartData = aDsply() (the array contains the rowlabels and the data and is a (17,2) array) the chart plots with either an extra column (R1) when I use the 1-17 loop or an extra column R18 when I use a 0-16 loop.
If I use the following section the data does not display: Anyone have an idea????
With MSChart1
col = 1
.chartType = VtChChartType2dBar
.ColumnCount = 1
.RowCount = 17
For row = 1 To .RowCount
.DataGrid.SetData row, col, arrBar(row), dataflag
Next row
With .DataGrid
.ColumnLabelCount = 1
.ColumnLabel(1, 1) = "Reported Concerns"
.RowLabelCount = 1
For ctr = 1 To 17
.RowLabel(ctr, 1) = aColLabel(ctr)
Next ctr
End With
.ShowLegend = True
End With