看了很久的帮助,也试了很多次,一直没成功这个Excel做出来的也不是我想要的最终效果,我想实现帮助里图示多列那样的效果,把男、女分开显示
Dim Chart As WinForm.Chart
Dim Series As WinForm.ChartSeries
Dim t As Table = Tables("EI")
Chart = e.Form.CreateControl("Chart1", ControlTypeEnum.Chart)
Chart.ChartType = ChartTypeEnum.Bar
Chart.SetBounds(0, 0, 600, 300)
Chart.BarClusterWidth = 90
Chart.Dock = System.Windows.Forms.DockStyle.Fill
e.Form.Controls("NavBar1").NavPages(2).AddControl(Chart)
For Each c As Col In t.Cols
If c.Name <> "性别" Then
Series = Chart.SeriesList.Add()
Series.Text = c.Name
Series.Length = t.Rows.Count
For r As Integer = 0 To t.Rows.Count - 1
Series.X(r) = r
Series.Y(r) = t.Rows(r)(c.Name)
Series.DataLabelText = "{#YVAL}"
Series.DataLabelCompass = LabelCompassEnum.North
Next
End If
Next
For r As Integer = 0 To t.Rows.Count - 1
Chart.AxisX.SetValueLabel(r, t.Rows(r)("性别"))
Next
Chart.AxisX.AnnoWithLabels = True
Chart.VisualEffect = True
Chart.LegendVisible = True
Chart.LegendCompass = CompassEnum.South
此段编码要怎么改才能实现我想要的效果