Pie chart and bar chart colours problem

[Hooch654]

Hi,

Total Newbie to the forum so I hope I am posting in the correct area - please be gentle with me!

I have two charts I am drawing using the XMChart plug in. One is a pie chart and the other is a bar chart, and both of them show exactly the same information. They report on certain types of incident called an NMPI and show the amount of different NMPI types recorded within a given date range.

What I want to do is to have the NMPI types be the same colour in both of the charts.

I have created a filed with a case statement the says (basically) Case (NMPI type = "1"; 135 50 50; NMPI Type = "2"; 145 88 141) and so on, setting the RGB value for each type of NMPI.

Which is all well and good, but how on earth do I then get the fill styles to be what I need?