Conditional Formatting in column (bar) charts
Excel does not support conditional formatting in charts, but we can solve it with a little trick. Original data will be split into a new table and then will be displayed by Stacked Column chart. The result will look like conditional formatting.
Example
Let us have following data table. We want to highlight a column in chart having a value less than 20.
Simple chart for this table looks like this:
How to automatically highlight columns? Continue reading “Conditional Formatting in column (bar) charts” »