Multiple Colored Bars in Dual Axis Chart

[jmonroe918]

I have created a Chart that uses both Y-axes. Left axis is Complaints (bar chart) and Right axis is Defect Rate % (Diamonds). By using this feature I no longer have the ability to select "Mulitcolored" for the bars (they are all blue). I would like them to be multicolored.

I have created conditions in the past based on > or < certain % would be represented by a certain color, but the bar charts are based on numbers and I don't want them colored based on their number. Just random.

Does anyone know of an expression that will give each bar its own color?

Thanks.

Jeff

[MarcoWedel · Accepted solution]

Hi,

the reason for the "Multicolored" being greyed out is your two expressions rather than the separate axes.

To multicolor the bars you could use a background color expression like:

hope this helps

regards

Marco

[jmonroe918]

Marco:

Worked like a charm!

Thanks so much.

Jeff