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
BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
7 years ago

Hi SoraiaT ,

 

Apologies for the necro, but I was trying to solve the same problem and came across this thread.

 

I solved this by moving the chart dimension from Legend into Axis. It appears that you can't conditionally format (nor sort sometimes) charts that use a legend.

 

I've attached examples of the difference in visual display just by moving the dimension. The chart using Axis is conditionally formatted based on rules.

 

Hope this helps you and/or anyone else that may stumble across this thread looking for answers.

 

Pete