Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Stacked Column chart conditional formatting not working correctly

Hello Community   I currently have a stacked column chart in which I have WEEK numbers on the axis and FTR roadtankers as value. FTR stands for "first time right" and it represents the percentage ...
Need Help
  • v-joesh-msft's avatar
    v-joesh-msft
    6 years ago

    Hi Anonymous ,

    The conditional formatting takes the difference between the minimum and maximum values as the cardinality of Percent, not the total. You need to adjust it to something like rules below:

    Best Regards,
    Community Support Team _ Joey
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

boyerusmc's avatar
boyerusmc
Frequent Visitor
6 years ago

Unfortunately, this isn't a solution for a STACKED COLUMN chart, only for column / clustered column charts. I'm still looking for a solution to this as well. I have a budget burn down chart - stacked column - where the full bar represents the entire budget with the "stack" being the remaining budget (balance) based on what's been billed. each column / bar is a different client. I would like to have any negative balances (more billed than total budget / below ZERO line) to be red.

 

Thanks!