Hi, I'm trying to show a data bar in a merged cell. I want the bar to be the correct length based on a min and max range listed above the merged cell. See image below. Based on the value in the merged cell the length of the data bar should almost reach the midpoint (orange line) of the merged cells but it is not. How can I get the length to be accurate? The width of each of the three columns that make up the merged cell is equal.
data bars 1.jpg
The image below shows the conditional formatting data bar settings.
data bars 2.jpg
Thanks in advance for your help.
Bookmarks