Dim Chart As New ChartBuilder
Dim Series As WinForm.ChartSeries '定义一个图系变量
Dim t As Table = Tables("批次统计临时表") '定义一个变量t引用数据表
Dim sm As Integer = t.Compute("Sum(各环节成本)") '计算总数量
Chart.VisualEffect = True '加上这一行,让你的图表更漂亮
Chart.ChartType = ChartTypeEnum.Pie '图表1类型改为Bar(条形)
Chart.SeriesList.Clear()
For Each r As Row In t.Rows
Series = Chart.SeriesList.Add() '增加一个图系
Series.Length = 1 '一个系列只能包括一个值
Series.Text = r("各环节名称") & "(" & Format(r("各环节成本"),"#,###.00") & ")" '设置图系的标题
Series.Y(0) = r("各环节成本") '指定值
If r("各环节名称") = "其他环节" Then '如果是其他环节
Series.Offset = 20 '那么图系偏离中心点20个像素.
End If
Series.DataLabelText = Math.Round(r("各环节成本")*100/sm,2) & "%" '计算百分比
Next
Chart.SaveImage(ProjectPath & "Images\myimg.wmf")
'生成Excel报表：
Dim Book As New XLS.Book(ProjectPath & "Attachments\销售统计.xls")
Book.Build()
Book.Save(ProjectPath & "Reports\销售统计.xls")
加好友 
发短信
Post By：2019/9/26 15:59:00 [显示全部帖子]
