Excel Conditional Formatting with Charts - Two Examples

Apply Conditional Formatting to your Excel charts to visualise the metrics that you need to see.

Excel does not have a Conditional Formatting feature that can be applied to charts. However, there is a simple way that we can do this.

You first need to write a logical formula to identify and show the values you want and hide the ones you don't. The IF function is perfect for this.

We then create our chart from this data and overlap the data series giving the appearance of Excel Conditional Formatting with charts.

You can apply any criteria that you want. Great for visualising actuals against target values, or the max and min values of a chart.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[wayneedmondson]

Hi Alan.. very clever trick. I'll be sure to put it to good use soon. Thumbs up!

[mohideenthassim]

very nice tutorial Alan, many thanks I will try this at my work place. Cheers Mohideen

[michaelfullard]

Thanks Alan, could be put to good use.

[pgcamp]

Alan, dumb question: how did you make the filter selections drop to the right instead of directly underneath Products?