Conditional Formatted Stacked Bar Charts

[bstboy]

Is there a way to conditionally format a stacked bar chart (say with 3 fields stacked) with each field independently looking off of a target and being formatting red or green when it either misses or hits the target?

By the way, the stacked bar charts increase over time as I want to cumulate the data each month. So February's stacked bar chart is bigger than January, Mar>Feb and so on. These will bump up against a trendline to show progress vs. an overall target. I want the conditional formatting so that we can pinpoint which of the 3 segments are causing the unfavorability if there is any.

 

[Steve=True]

Hi BstBoy,

You can do this, but you may have to manage your legend and if you have more than 3 stacks, it will be hard to distinguish which section of the stack is not meeting or missing if the adjacent one is also meeting or missing. See the graphic below.

You can do this buy using the NA() function:

Here is an example
http://www.exceldashboardtemplates.com/?p=696

Steve = True