Please add the ability in conditional formatting to show "Data bars" based on a different field. Just like you can show "Background color" or "Font color" based on a field you can choose. At this moment it is not consistent behaviour and I really need this for managementreporting as I want to show the numbers in the columns but show the bars based on a percentage that is spend.
Lots of love!
- Comments (12)
Comments (12)
RE: Conditional formatting in matrix by field doesn't work with data bars
This would, be a great function.
RE: Conditional formatting in matrix by field doesn't work with data bars
Agreed, this is needed. The "Base Value" in the Data bars formatting menu is currently unchangeable.