Doughnut help!

[mayseed]

Hi everyone.. I am cranking nicely and steadily with my database.. many thanks for macropod :beerchug: help i've been able to progress a long way now.

My new issue is this: (am using an access database for this): :banghead:

I am trying to include an interactive doughnot chart/diagram ( I attached a copy of what I really need) and then need to change the colours of different portions according to the value of a field attached to that portion.

Take a look at the diagram and it will make it easier to understand.

So the idea is to have a drop down box next to each segment of the bullseye diagram, which gives you 4 options:

1. 0-25%
2. 25-50%
3. 50-75%
4. Normal

If the Normal option is chosen then the corresponding segment should be coloured with green.

If the 0-25% options is chosen then the corresponding segment should be colored with yellow.

If the 25-50% option is chosen then the corresponding segment should be coloured with orange

If the 50-75% option is chosen then the corresponding segment should be coloured with red


I was just wondering about the easiest way of doing this? any thoughts much appreciated.:p

Thanks in advance.:friends:

[AbigailBass]

Has your issue solved. I am not able to post links.

[mayseed]

Sorry Abigail. didnt quite understand what u said?