crystal bar chart multiple criteria

[mijiaus]

I try to create a bar chart base on two table, and my question is that, does crystal support the multiple criteria such that I can use to represent our data. Situation like this: I want to show the Top 20 prices in red color and green for rest of them. (Y axis : Price, X axis: matural_date) and also in the same chart, another criteria changes the all color of items(bar) whose price id show up in another table.(table1) to blue,
I have finished top 20 prices in red color, but it seems that I can't find a proper way to accomplish the coloring against products show up on second table. ( productID and matural_date has one to one relationship)

table 1:
productID price matural_date

table 2
ProductID

Thanks for answering how to create such bar chart.