Format bar chart colour according text

[andrefraga]

I have the following set of data:

[TABLE="width: 297"]
<tbody>[TR]
[TD]NAME[/TD]
[TD]TYPE[/TD]
[TD]VALUE[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]GA[/TD]
[TD="align: right"]-0,8[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]GI[/TD]
[TD="align: right"]0,5[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]PO[/TD]
[TD="align: right"]0,5[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]GI[/TD]
[TD="align: right"]-0,8[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]PO[/TD]
[TD="align: right"]-0,41[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I'll create a bar chart with the data in collumns NAME and VALUE. It's a simple bar chart.
But I would like to colour the bars of my chart according to the TYPE collum, for example, GA = Red, GI = Blue and PO = Green.
Could anyone help me?
Thanks!