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 '标示字体白字
..........................................
谢谢!
加好友 
发短信
Post By：2019/11/6 20:02:00 [只看该作者]
此主题相关图片如下：图表图形标题在图下方箭头位置45°显示.jpg