I have added data bars to some percentage formatted cells in Excel.
As you can see, the bars do not accurately represent the percentages. For example, the 78% bar looks like 99%. I tried going to Conditional Formatting > Mange Rules, and changing the Minimum to percent = 0/maximum = Automatic, but that distorted the bars even worse. What am I doing wrong here?