In this database I have a field in a table which contains the current ending balance and a field from another table that contains the amount of every transactions during the year. 

•  The first problem is that I need to begin at the proper starting point and show the activity in chronological order, but how to get this starting point?  Calculated field, but I don't think that would work with a graph?
• The second problem is that it needs to be in a graph format, but because of the first issue, I am having a hard time visualizing how to create the graph (don't get me wrong, I have created graphs before, but since all the data was all laid out in the tables and in the proper order, it was quite easy).

So this is what I want to accomplish with the following example:

Ending balance:
31/01/2011  1,000
 
YTD transactions:
01/01/2011    30
10/01/2011   100
15/01/2011  -500
 
So the starting point would be $1,370 (1,000 - 30 - 100 + 500)
So the graph points would obviously look like this:
#1  $1,370
#2  $1,400
#3  $1,500
#4  $1,000