conditional formating in bar chart

[dsg1]

Hi,

I have a report where I am using a bar chart. In the Y-axis we have the various products and in the Series we have the revenue actual and revenue target.

I want to conditionally format the revenue actual data , i.e different colour of the actual bars based on different conditions.

I have created a conditional variable with the values and in the conditional pallete when I am assigning the string variable, both the fields revenue actual and target is actually getting conditionally formatted. However I want only the actual field to get formatted .

Also I need a bar which shows the total actual and targetted revenue. Is this possible?

Need help.

Thanks.