Fix colours in a pie chart

[tabaki]

I have a pie chart on which I display all type problems that may occur in an intallation.

Now I 've got to show this every month. It should be useful that problem type 1 should always appear in blue, and problem type 2 always in yellow.
Now it shows the first record in blue, the second in pink ...

How do I do this?

I've got a table: TblProblems in which I have the field Type and the field when the problem occurs. The Type field is bound to the table LstType in which all the problems are specified.

 

[seaport]

How did you make the pie chart in Access? Is this a new feature in Access 2003?

Seaport