Problem with the Bar chart colour

[#1]

Hi All,

I have a bar chart

X axis it is a measure shows Sales, Quantity,Gross Profit

Y Axis it have an option to select Salesman, Customer, etc.

The bar chart is shown in blue color what ever i select whether it is sales , salesman or anything

Now i have added one more Expression to extract the one of the field (This expression is not shown in graph but this value is shown when data is exported to Excel)

Everything is fine but now the bar chart color is changing according to the selections which i make in X axis and Y axis.

I don't want it to happen the bar chart should be only in blue color

Can some one help on this

[Gysbert_Wassenaar]

Click on the + in front of the expression on the Expressions tab and select Background color. Enter color(0) as expression. Do this for all the expressions in your chart.

[jonathandienst · Accepted solution]

Hi

Check the Persistent Colors check box on the chart properties Colors tab

HTH

Jonathan