专家坐堂-[讨论]图表图形标题Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

Dim Chart As WinForm.Chart \'定义一个图表变量

Dim Series As WinForm.ChartSeries \'定义一个图系变量

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

Chart.VisualEffect = True \'加上这一行,让你的图表更漂亮

Chart.ChartType = ChartTypeEnum.Bar \'图表年月该为Bar(条形)

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

Chart.AxisY.Min = 0 \'指定Y轴的最小值

Chart.DataFilter = Tables("月度统计").Filter

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

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

Series.Text = "本月盘存_金额"

Series.X.DataField ="年月" \'X轴绑定到产品列

\'Series.X(i) = i \'指定水平坐标\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'

Series.Y.DataField = "本月盘存_金额" \'Y轴绑定到数量列??

Series.DataLabelText = "{#YVAL}"\'数据标示

Series.DataLabelCompass = LabelCompassEnum.North \'标示显示位置

Series.FillColor = Color.Lime \'图状颜色填充

Series.DataLabelForeColor = Color.White \'标示字体白字

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

Series.Text = "上月盘存_金额"

Series.X.DataField ="年月" \'X轴绑定到产品列

\'Series.X(i) = i \'指定水平坐标\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'\'

Series.Y.DataField = "上月盘存_金额" \'Y轴绑定到数量列??

Series.DataLabelText = "{#YVAL}"\'数据标示

Series.DataLabelCompass = LabelCompassEnum.North \'标示显示位置

Chart.AxisX.AnnoWithLabels = True \'启用字符标示

Chart.LegendVisible = True \'显示图列

Series.FillColor = Color.Red \'图状颜色填充

Series.DataLabelForeColor = Color.White \'标示字体白字

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

Series.Text = "本月盘存_数量"

Series.X.DataField = "年月" \'X轴绑定到产品列

Series.Y.DataField = "本月盘存_数量" \'Y轴绑定到数量列

Series.DataLabelText = "{#YVAL}" \'数据标示

Series.DataLabelCompass = LabelCompassEnum.North \'标示显示位置

Series.FillColor = Color.Blue \'图状颜色填充

Series.DataLabelForeColor = Color.White \'标示字体白字

..........................................

谢谢!