Search code examples
excelcellconditional-formatting

Data bars in Excel not accurate


I have added data bars to some percentage formatted cells in Excel.

enter image description here

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?

enter image description here


Solution

  • Change your maximum value to 1.

    enter image description here

    enter image description here