Forum Discussion
SoraiaT
Helper I
Helper IConditional 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
SoraiaTHelper I
Helper IHi 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
- SoraiaTHi 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