CODEWITHSUNDEEP
excelcellconditional-formatting
gwydion93
gwydion93

Reputation: 1923

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

Upvotes: 3

Views: 8843

Answers (2)

JeffC
JeffC

Reputation: 1

In my own testing, I find that both the data bars and the color scales always seem to work in relation to existing numbers in the list, rather than in relation to a defined maximum - regardless of whether I set it to Number or Percent. Setting it to Number APPEARED to work at first, but once I started adding and changing numbers, the conditional formatting lost all rhyme/reason.

Upvotes: 0

Isolated
Isolated

Reputation: 6454

Change your maximum value to 1.

enter image description here

enter image description here

Upvotes: 9

Related Questions