Bar Chart problem

[Urvi]

I have generated a horizontal bar chart from my access table which shows the top10 and bottom10 suppliers for a particular period.

i am able to get 1 color or multi colors for my bars but what i want is that the top10 be 1 color and the bottom 10 be another color.

Is there anyway i can use just 2 colors and specify them for the top and bottom suppliers?


thanks for help in advance

[OTWarrior]

how have you created this bar chart? have you pushed the data to excel and used it to generate this bar chart? or is it on a form in access?

if it is the former, then you are able to do it manually..if so I will dig up my code.

[Urvi]

It is on a report in access...
i want it automated without any manual work on the part of the end user