Conditional formatting with thresholds
Data in graphs can be sorted the same way as we sort a grid (with the Data | Advanced Sorting menu). Take the previous recipe as an example: if you sort the data by Product Category, you will see the Accessories bar in the first place on the left.
We can also apply conditional formatting to the color of the series by using thresholds.
Getting ready
You should have completed the previous recipe to continue.
How to do it...
Let's see an example; say that you want the negative values of Product Margin to shout out loud in your chart:
Run the 24 Product Margin vs. Sales Amount by Category report.
Once the chart appears, click on menu Data | Thresholds.
In the Thresholds window the Sales metric is selected by default and an empty condition is created. We need to remove this one before going on, so click on the small button labeled Delete on the toolbar, the one that has an X icon like the this:
Answer Yes to the message asking you if you want to delete the threshold...
