form1.frm

vb精彩编程希望大家有用

VERSION 5.00
Object = "{65E121D4-0C60-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCHRT20.OCX"
Begin VB.Form Form1 
   Caption         =   "图表演示"
   ClientHeight    =   4740
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   6060
   LinkTopic       =   "Form1"
   ScaleHeight     =   4740
   ScaleWidth      =   6060
   StartUpPosition =   3  '窗口缺省
   Begin MSChart20Lib.MSChart MSChart1 
      Height          =   3975
      Left            =   0
      OleObjectBlob   =   "Form1.frx":0000
      TabIndex        =   4
      Top             =   0
      Width           =   6015
   End
   Begin VB.CommandButton Command4 
      Caption         =   "读入Excel"
      Height          =   495
      Left            =   4440
      TabIndex        =   3
      Top             =   4080
      Width           =   1215
   End
   Begin VB.CommandButton Command3 
      Caption         =   "带标签图表"
      Height          =   495
      Left            =   3120
      TabIndex        =   2
      Top             =   4080
      Width           =   1215
   End
   Begin VB.CommandButton Command2 
      Caption         =   "多系列图表"
      Height          =   495
      Left            =   1680
      TabIndex        =   1
      Top             =   4080
      Width           =   1215
   End
   Begin VB.CommandButton Command1 
      Caption         =   "简单图表"
      Height          =   495
      Left            =   360
      TabIndex        =   0
      Top             =   4080
      Width           =   1095
   End
End
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Base 1
Private Sub Command1_Click()
    Dim data(10) As Integer
    Dim i As Integer
    For i = 1 To 10
        data(i) = Int(Rnd * 100)
    Next
    MSChart1.ChartData = data
End Sub
Private Sub Command2_Click()
    Dim data(10, 3) As Integer
    Dim i As Integer, j As Integer
    For i = 1 To 10
        For j = 1 To 3
            data(i, j) = Int(Rnd * 100)
        Next j
    Next i
    MSChart1.ChartData = data
End Sub
Private Sub Command3_Click()
    Dim data(5, 4)
    Dim i As Integer, j As Integer
    For i = 1 To 5
        data(i, 1) = Str(i) & "分组"
        For j = 2 To 4
            data(i, j) = Int(Rnd * 100)
        Next j
    Next i
    MSChart1.ChartData = data
End Sub
Private Sub Command4_Click()
    Dim myexcel As New Excel.Application
    Dim wkb As Object
    Dim data(6, 5)
    Dim i As Integer, j As Integer
    myexcel.Workbooks.Open FileName:=App.Path & "\xs.xls"
    Set wkb = myexcel.ActiveSheet
    For i = 1 To 6
        data(i, 1) = wkb.Cells(1, i + 1)
        For j = 2 To 5
            data(i, j) = wkb.Cells(j, i + 1)
        Next j
    Next i
    MSChart1.ChartData = data
End Sub
Private Sub Form_Load()
    Randomize Timer
End Sub