Excel dynamic chart

Hi guys,

I'm trying to create a dynamic chart under excel 2007 and It seems I am not good enough to get it working !

I have a table of parts I buy from several suppliers, this table is generated by a macro so the data is not static. Basically, I would like to get a chart of how much money do I spend on each supplier. I cannot fix the suppliers in advance, the chart will have to update them by itself.

You will find an example of my table in attachments, can someone point me in the good direction ?

Thanks !