vb 调用excel做趋势线

.Charts.Add

你第一次添加了一个图表

第二次是打算再添加一个？还是选中上次添加的那个？

如果你再添加，那么名称肯定不叫 "图表 1"了

如果你修改原有的图表 1，就不要再add，而是select。

方法一：Excel中就可以实现；

方法二：通过VB.net将数据写入到Excel中生成趋势图；

方法三:直接通过VB.net写出这种趋势图。

具体方法可以参考VB.net *** 作Excel方法:http://hi.baidu.com/jonesvale/blog/item/3134ff1ecebdfc64f724e44b.html

可用代码：

For i = 0 To iRow - 1

pointXY(i) = "'这里你可以直接放上你的数据点值在X线上

"

pointYY(i) = "'这里你可以直接放上你的数据点值在Y线上

Next

Private Sub DrawRectangle()

Try

Dim oV2Bar As New Graphing.V3.Bar.BarChart()

Dim renderer As New Graphing.V3.Render

PictureBox1.Image = renderer.DrawChart(oV2Bar, Xline,Yline iRow, pointXY, pointYY)

End If

Catch ex As Exception

MsgBox(ex.Message)

Public Class BarChart : Inherits Base.BaseGraph

'This will hold the Bar pieces.

Public BarSliceCollection As New Bar.BarPieceCollection()

Private _Alignment As Base.b_BarTypes = Base.b_BarTypes.HorizontalLeft

Public Property Alignment() As Base.b_BarTypes

Get

Return _Alignment

End Get

Set(ByVal Value As Base.b_BarTypes)

_Alignment = Value

End Set

End Property

'Private _ChartType As Base.b_ChartType = Base.b_ChartType.Bar

Public Shadows ReadOnly Property ChartType() As Base.b_ChartType

Get

Return MyBase.ChartType

End Get

End Property

Sub New()

MyBase.new()

MyBase.ChartType = Base.b_ChartType.Bar

End Sub

Sub New(ByVal BarPieceCollection As BarPieceCollection)

MyBase.new()

MyBase.ChartType = Base.b_ChartType.Bar

BarSliceCollection = BarPieceCollection

End Sub

End Class

End Try

End Sub

---