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.

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.

Illustrated scale comparison. Inspect both rules after reopening.



