Creating a Conditional Color Palette in a Chart

You can create a conditional palette to color data items in your chart in different ways depending on a condition. For example, in a column chart that shows revenue per month, you want to make the columns for the months that have a revenue greater than $1000000 green.

You can also use conditional styles to highlight exceptional data and use conditions to control the layout of your report.