This content has been marked as final. Show 4 replies
Hi, i have a fixed set of colors per product type that i need to use in the background and also have labels displayed on the color (product type or % figure), as well as the legend. The attached screenshot is an example.
Under Appearance > Colors and legend > By Expression, I have tried this expression:
If([Product Type] ='Product A',RGB(188,204,228),If([Product Type] ='Product B',RGB(148,180,212),If([Product Type] ='Other',RGB(52,100,148))
The above works in displaying the colors, but does not display the labels and the Legend next to the chart.
Could you please suggest an easy way to do fix the colors as well as display the labels and the legend. Much appreciated.