excel chart and formula

[guyzk1]

Hi,

I need someone to help me set up an excel chart with formulas.
I have an investor who invests in my company we use his money for buying certain items and split the profit 50-50.
I need a chart to show me the status of his money + the profit made on the sold items (which he leaves in the company) and to know as well where is his money still invested (which items and the amount).
We will also need a column of his withdrawals as well.
I know this is a lot of work but could somebody help me please.

[tuph]

The first thing you do is set up a worksheet containing columns for the data and formulas you want to chart, then select the range of cells and create the chart.