A cell that should have a 50% bar has one that is closer to 70%.
What might I be doing wrong?
Alan
Not sure why I had to do this but set the values to-
Min,Formula=0
Max,Formula=1
and it is working correctly.
When you don’t specify min and max, the values in the range are analyzed to calculate min and max, and min gets 0%, max gets 100%. The numbers aren’t treated as percents themselves; it doesn’t matter that you have formatted them to be shown as percents - for LO they are just some numbers. So, without explicit limits definition, you may get “strange” results.