
November 23rd, 2003, 03:30 PM
|
|
Contributing User
|
|
Join Date: Sep 2003
Posts: 48
Time spent in forums: 2 h 39 m 46 sec
Reputation Power: 6
|
|
Code:
If (Time.Text = "This Week") Then
Open (App.Path & "\records\records.tkf.txt") For Input As #1
While iLines < 7
Line Input #1, temp$
sCurrentRecord = temp$
iLines = iLines + 1
iPos = InStr(sCurrentRecord, ">")
sMoney = Right(sCurrentRecord, (Len(sCurrentRecord) - iPos))
sMoney2 = Val(Right(sMoney, (Len(sMoney) - 1)))
iMoney = Val(sMoney2)
If (Left(sMoney, 1) = "+") Then
iMoneyOverTime = iMoneyOverTime + iMoney
Else
iMoneyOverTime = iMoneyOverTime - iMoney
End If
MSChart1.RowCount = 7
MSChart1.Column = 2
MSChart1.Row = iLines
MSChart1.Data = iMoneyOverTime
Wend
Close #1
iLines = 1
While iLines < 7
MSChart1.RowCount = 8
MSChart1.Column = 1
MSChart1.Row = iLines
MSChart1.Data = iLines
iLines = iLines + 1
Wend
the graph should sort the money, over days, the graph ends up looking like this:
---------
| \ |
| / |
| / |
| \ |
| \ |
| \ |
--------
very skinny, and no labels(but it appears that the points that are put on are correct
|