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

[Onne]

Hi!

I was wondering if this is possible.
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 but when my data changes 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 don't know if this is possible in the first
place but I wanted to give it a shot!

Thanks in advance!
Greetings, Onne (NL)