图表问题---(已经完美解决-----感谢谢狐爸) - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

下载信息 [文件大小：下载次数： ]
点击浏览该文件:管理项目60.table

你的表本来就只有计划和完成两个数据、

必须双图表的，不过效果一样：

下载信息 [文件大小：下载次数： ]
点击浏览该文件:图表.foxdb

Dim t As Table = Tables("统计表")
Dim Chart As WinForm.Chart '定义一个图表变量
Dim Series As WinForm.ChartSeries '定义一个图系变量
Dim Series2 As WinForm.ChartSeries '定义一个图系变量
Chart= e.Form.Controls("Chart1") ' 引用窗口中的图表
Chart.SeriesList.Clear() '清除图表原来的图系
Chart.ChartType =ChartTypeEnum.Bar
Chart.ChartType2 = ChartTypeEnum.XYPlot
Chart.SeriesList.Clear
Chart.SeriesList2.Clear
Chart.VisualEffect= True
Dim nms() As String = {"计划","完成"}
Chart.AxisY.Min = 0
Chart.AxisY2.min = 0
Chart.AxisY.max = math.Max(t.DataTable.Compute("max(计划)"),t.DataTable.Compute("max(完成)"))
Chart.AxisY2.max = Chart.AxisY.max
Chart.AxisY.Text = "计划"
Chart.AxisY2.text = "完成"
chart.LegendVisible = True
Chart.LegendCompass = CompassEnum.South
For Each nm As String In nms
    Series = Chart.SeriesList.Add
    Series2 = Chart.SeriesList2.Add
    Series.Length = t.Rows.Count
    Series2.Length = t.Rows.Count
    Series2.MarkSize = 0
    Series2.MarkBorderWidth = 0
    Series2.FitType = FitTypeEnum.Spline
    Series.Text = nm
    series2.Text = nm
    For i As Integer = 0 To t.Rows.count - 1
        Series.X(i) = i '指定水平坐标
        Series.Y(i) = t.Rows(i)(nm)
        Series2.X(i) = i '指定水平坐标
        Series2.Y(i) = t.Rows(i)(nm)
        Chart.AxisX.SetValueLabel(i, t.Rows(i)("月份")) '指定字符表
    Next
Next

Dim t As Table = Tables("统计表")
Dim Chart As WinForm.Chart '定义一个图表变量
Dim Series As WinForm.ChartSeries '定义一个图系变量
Dim Series2 As WinForm.ChartSeries '定义一个图系变量
Chart= e.Form.Controls("Chart1") ' 引用窗口中的图表
Chart.SeriesList.Clear() '清除图表原来的图系
Chart.ChartType =ChartTypeEnum.Bar
Chart.ChartType2 = ChartTypeEnum.XYPlot
Chart.SeriesList.Clear
Chart.SeriesList2.Clear
Chart.VisualEffect= True
Dim nms() As String = {"计划","完成"}
Chart.AxisY.Min = 0
Chart.AxisY2.min = 0
Chart.AxisY.max = math.Max(t.DataTable.Compute("max(计划)"),t.DataTable.Compute("max(完成)"))
Chart.AxisY2.max = Chart.AxisY.max
Chart.AxisY.Text = "计划"
Chart.AxisY2.text = "完成"
chart.LegendVisible = True
Chart.LegendCompass = CompassEnum.South
For Each nm As String In nms
    Series = Chart.SeriesList.Add
    Series2 = Chart.SeriesList2.Add
    Series.Length = t.Rows.Count
    Series2.Length = t.Rows.Count
    Series2.MarkSize = 0
    Series2.MarkBorderWidth = 0
    Series2.FitType = FitTypeEnum.Spline
    Series.Text = nm
    series2.Text = nm
    Series.TooltipText = nm & ":{#YVAL}"
    Series2.TooltipText = nm & ":{#YVAL}"
    For i As Integer = 0 To t.Rows.count - 1
        Series.X(i) = i '指定水平坐标
        Series.Y(i) = t.Rows(i)(nm)
        Series2.X(i) = i '指定水平坐标
        Series2.Y(i) = t.Rows(i)(nm)
        Chart.AxisX.SetValueLabel(i, t.Rows(i)("月份")) '指定字符表
    Next
Next

主题：图表问题---(已经完美解决-----感谢谢狐爸)