Forum Discussion

SoraiaT's avatar
SoraiaT
Icon for Helper I rankHelper I
7 years ago

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
Need Help
SoraiaT's avatar
SoraiaT
Icon for Helper I rankHelper I
7 years ago

Hi Anonymous Lidia,

 

I have the latest verson. Download again and that option keeps not showing:

 

Do you have any idea why?

 

Thanks  again :)

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

  • SoraiaT's avatar
    SoraiaT
    Icon for Helper I rankHelper I
    7 years ago
    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!
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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

      • SoraiaT's avatar
        SoraiaT
        Icon for Helper I rankHelper I
        7 years ago
        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