Thread: Create Chart with calculated cell values

Hi all,
I am struggling to create a normal column chart, my requirement is

I have three colums

Code:

product        Transtype        Quantity 
abc              buy                100
xyz              buy                 50
xxx               buy                200
abc              sell                 50
yyy              buy                 25
xxx              sell                  150

the table contains the product names, the transaction type (buy/sell) and the quantity. Now I have to create a chart with unique product names in the x-axis and the available quantity of each product (after buy and sell) in the y-axis. being a starter with excel programming I am struggling to accomplish this task. can anyone please help me in completing this.

Thanks in advance
JP