Forum Discussion
Conditional Formatting of Bar Chart
Hi, Does anyonw knows how to add conditional formating to bar chart? There are no options on the Format-> Colour or at the collum like on tables. Thanks! Soraia
SoraiaT,
When you directly drag two fields to Values section of the column chart, please manually change color for each field.
If you drag field to Axis and Values to column chart as below, you will have the advanced control option.
Regards,
Lydia
Hi Anonymous, The data are in a single row. what I want to see is the value on the column "A" and the value on the column "B". If the value on "B" is higher and lower than "A" i would like to see different colours. Is there a way to do this? Thanks!
SoraiaT,
As my previous post, if you drag two columns, it is only possible to manually set the colors for each column. If you want to set colors for each column based on the condition as you describe, you can use table visual and configure conditional formatting.
Regards,
Lydia- Hi Anonymous, Thank you. I want one of the columns to change colour based a condition. I've followed your steps but to see both values in the graph, the colour doesn't change. Can you download the example I've created with this link: https://we.tl/t-krmDnXIPB0 Should I do something different? Thx again, Soraia
SoraiaT,
In your second chart, please click Advanced controls to configure conditional formatting as below.
Regards,
Lydia