Subject: Change chart-bar colours when field-value is "X"

[Onne]

Hi!

I'm trying to get this done:

I use a table like this (sample data):
________________________
Column1, Column2, Column3
________________________
2005, 60, NOK
2006, 50, OK
2007, 20, OK
________________________

When I make a bar-chart (Column1 at the X-axel, Column2 at Y-axel) on this
data all bars have the same colour.
I can change these colours manually but when my data changes (OK becomes
NOK) this lay-out isn't saved of course.

Wat I like to do is something like this:

"If column3 is "ok" then colour this bar in the chart green."

I'm a beginner with access and would be very gratefull with any reaction!

Thanks in advance!
Greetings, Onne (NL)