我是想实现饼状图,柱状图,如果可以的话加上折线图 这是我画瓢的一个程序, Private Sub Command1_Click() Dim i As Integer Dim NewDyn As Recordset Dim OpenWs As Workspace Dim OpenDB As Database Set OpenWs = DBEngine.Workspaces(0) Set OpenDB = OpenWs.OpenDatabase("D:\abc\db1.mdb ") Set NewDyn = OpenDB.OpenRecordset("select*from Provinces_R ", dbOpenSnapshot) NewDyn.MoveLast NewDyn.MoveFirst If NewDyn.RecordCount = 0 Then MsgBox "请在数据库中输入数据!”vbCritical" Exit Sub End If With MSChart1 .TitleText = "直方图示例" .RowCount = NewDyn.RecordCount For i = 1 To NewDyn.RecordCount .Row = i .Data = NewDyn.Fields("disease_num") .RowLabel = NewDyn.Fields("city_name") NewDyn.MoveNext Next i End With NewDyn.CloseEnd SubPrivate Sub Command1_Click() Dim i As Integer Dim NewDyn As Recordset Dim OpenWs As Workspace Dim OpenDB As Database Set OpenWs = DBEngine.Workspaces(0) Set OpenDB = OpenWs.OpenDatabase("D:\abc\db1.mdb ") Set NewDyn = OpenDB.OpenRecordset("select*from Provinces_R ", dbOpenSnapshot) NewDyn.MoveLast NewDyn.MoveFirst If NewDyn.RecordCount = 0 Then MsgBox "请在数据库中输入数据!”vbCritical" Exit Sub End If With MSChart1 .TitleText = "直方图示例" .RowCount = NewDyn.RecordCount For i = 1 To NewDyn.RecordCount .Row = i .Data = NewDyn.Fields("disease_num") .RowLabel = NewDyn.Fields("city_name") NewDyn.MoveNext Next i End With NewDyn.CloseEnd Sub 但是运行出来以后,为什么x轴的city_name不清楚呢?而且和excel作出来的柱状图不一样,感觉很别扭呢?当然我做的这个是直方图,可是我在charttype中找不到柱状图啊? 多谢啊!!!
这个帖子很详细的mschart的例子,你看看
这是我画瓢的一个程序,
Private Sub Command1_Click()
Dim i As Integer
Dim NewDyn As Recordset
Dim OpenWs As Workspace
Dim OpenDB As Database
Set OpenWs = DBEngine.Workspaces(0)
Set OpenDB = OpenWs.OpenDatabase("D:\abc\db1.mdb ")
Set NewDyn = OpenDB.OpenRecordset("select*from Provinces_R ", dbOpenSnapshot)
NewDyn.MoveLast
NewDyn.MoveFirst
If NewDyn.RecordCount = 0 Then
MsgBox "请在数据库中输入数据!”vbCritical"
Exit Sub
End If
With MSChart1
.TitleText = "直方图示例"
.RowCount = NewDyn.RecordCount
For i = 1 To NewDyn.RecordCount
.Row = i
.Data = NewDyn.Fields("disease_num")
.RowLabel = NewDyn.Fields("city_name")
NewDyn.MoveNext
Next i
End With
NewDyn.CloseEnd SubPrivate Sub Command1_Click()
Dim i As Integer
Dim NewDyn As Recordset
Dim OpenWs As Workspace
Dim OpenDB As Database
Set OpenWs = DBEngine.Workspaces(0)
Set OpenDB = OpenWs.OpenDatabase("D:\abc\db1.mdb ")
Set NewDyn = OpenDB.OpenRecordset("select*from Provinces_R ", dbOpenSnapshot)
NewDyn.MoveLast
NewDyn.MoveFirst
If NewDyn.RecordCount = 0 Then
MsgBox "请在数据库中输入数据!”vbCritical"
Exit Sub
End If
With MSChart1
.TitleText = "直方图示例"
.RowCount = NewDyn.RecordCount
For i = 1 To NewDyn.RecordCount
.Row = i
.Data = NewDyn.Fields("disease_num")
.RowLabel = NewDyn.Fields("city_name")
NewDyn.MoveNext
Next i
End With
NewDyn.CloseEnd Sub
但是运行出来以后,为什么x轴的city_name不清楚呢?而且和excel作出来的柱状图不一样,感觉很别扭呢?当然我做的这个是直方图,可是我在charttype中找不到柱状图啊?
多谢啊!!!
我把charttype里面每个都试了一遍,没发现啊?
难道是版本低?