Conditional Formatting Query

[jmcp]

Hi 

I would like to add some conditional formatting to a 100% stacked column chart.   If a value falls below my target line % i want the column to automatically display a different colour compared to when the value is above my target line %.

I need to know how to navigate to the conditional formatting options for a 100% stacked column chart in order to input my conditions.

thanks!

[PhilipTreacy · Accepted solution]

Hi @jmcp 

Unfortunately this is not possible.  When you have more than 1 series of data in the chart, the Conditional Formatting functionality is not available.

Regards

Phil