Hi all,

 

I would like to plot the following chart using Crystal Reports XI.

 

 

The following is the table design and data for plotting the above graph. The join condition is TABLE1.PARAM_GID = TABLE2.GID.

 

 

I would like to change color of the bar if the WEAKEST flag is 'Y' and set the legend such that there are four entries. I have tried to use four disjoint sets in my sql (i.e. weakest = 'Y' union weakest = 'N') but it turns out the result chart is not what I want.

 

Could you please help?