Option Explicit Private rsProducts As New ADODB.Recordset Private cn As New ADODB.Connection Private Sub Form_Load() Dim strQuery As String cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & App.Path & "\Data.mdb " cn.Open strQuery = "SELECT aa,bb,cc from table" rsProducts.Open strQuery, cn, adOpenKeyset With msChart1 .ShowLegend = True Set .DataSource = rsProducts .Title.Text = " 测试数据 " '显示标题 .Title.VtFont.Effect = VtFontEffectUnderline .Title.VtFont.Size = 10 .Title.VtFont.VtColor.Set 255, 0, 255 End With End Sub Private Sub Command1_Click() End End Sub在属性中将 msChart1.chartType设成饼图
Private rsProducts As New ADODB.Recordset
Private cn As New ADODB.Connection
Private Sub Form_Load()
Dim strQuery As String
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & App.Path & "\Data.mdb "
cn.Open
strQuery = "SELECT aa,bb,cc from table"
rsProducts.Open strQuery, cn, adOpenKeyset
With msChart1
.ShowLegend = True
Set .DataSource = rsProducts
.Title.Text = " 测试数据 " '显示标题
.Title.VtFont.Effect = VtFontEffectUnderline
.Title.VtFont.Size = 10
.Title.VtFont.VtColor.Set 255, 0, 255
End With
End Sub
Private Sub Command1_Click()
End
End Sub在属性中将
msChart1.chartType设成饼图