Hi,
I'm trying to use data bars via conditional formatting on percentage data, however the data bars display incorrect information.
The example sheet will explain it better than that sentence.
Hi,
I'm trying to use data bars via conditional formatting on percentage data, however the data bars display incorrect information.
The example sheet will explain it better than that sentence.
The data bars are working correct as set up.
They assign the total percentage (100) across the cells which contain a value to add up to 100%
So A1 has 0.0830564784053156
A2 has 2
A3 has 1
Total number is 3.0830564784053156
So B1 = 3% of the total
B2 = 65%
B3 = 32%
Are you hoping that as your value is 2% you will only show 2% fill in that cell? As opposed to a data bar across the range?
Please do add reputation where you see fit, it's nice to be nice and we all enjoy a pat on the back
Please also mark your thread as solved once it has been.
My assumption based example
I wasn't aware that was how they worked thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks