Need chart advice!

[EURUSD]

I have created a Worksheet that presents a companys foreign currencytransactions.

The next step for me is to try to summerize the different currency exponations the company had.
I tried to do this in a pivot-table but I cant really get it to work.

The important thing for me is that you can be able to see the aggregate positions in the different
currencies for each date. Is this possible or do I have to reconsider?

Sheet 1 (Rates&Trade) - Dont mind this one
Sheet 2 (Trade-Journal) - The sheet with all new positions
Sheet 3 (Chart&Table) This is where I tried to make a graph but as you can see it doesnt consider aggregation.

Whats your advice?


------------------------------------------------------------
EURUSD using Excel 2010

Division1.xlsm

[darknation144]

Probably shouldn't be posting this on a public forum unless you made up all the amounts.

[EURUSD]

ofcourse this is only fictive numbers...... what d you think about the possibility of charting aggregate amounts?