North recorded 20, 40, and 50. South recorded 40, 60, and 80. Both groups measure capacity on a 0–100 scale, so the two values of 40 should look equal.

Give both data-bar rules the same bounds

In an editor with configurable data bars, apply a rule to the North cells with numeric minimum 0 and maximum 100. Repeat those bounds for South. Read the two values of 40 and compare their bars. Leave the numeric values visible.

Both entries of 40 have equal bar lengths on a 0–100 scale.

Illustrated calibration check. Keep the underlying numbers visible.

Check the saved rules in the receiving editor

Reopen the XLSX and inspect both ranges. If 40 looks different between them, check each rule’s numeric bounds and its applies-to range. With automatic bounds, the North values span 20–50 and the South values span 40–80. Record the shared 0–100 scale beside the results.

North and South have different automatic bounds, which can make equal values look different.

Illustrated scale comparison. Inspect both rules after reopening.

Microsoft’s reference for conditional-formatting data bars