专家坐堂-图表怎样能不显示0值Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

Chart = e.Form.Controls("Chart2") \' 引用窗口中的图表

Chart.ChartType = ChartTypeEnum.Bar \'图表类型改为Bar(条形)

Chart.DataSource = "统计表2" \'设置绑定表

chart.DataFilter = "部门 = \'" & e.Sender.value & "\'"

Chart.SeriesList.Clear() \'清除图表原来的图系

For Each c As Col In t.Cols

If c.name <> "部门" AndAlso c.name <> "总计" Then \'

Series = Chart.SeriesList.Add() \'增加一个图系

Series.Text = c.Name \'设置图系的标题

Series.X.DataField = "部门" \'X轴绑定到产品列

Series.Y.DataField = c.Name \'设置Y轴的绑定列

Series.DataLabelText = "{#YVAL}"

End If

Chart.LegendVisible = True \'显示图列