The problem is in plotting single start bar (sum of Actual for all accounts) and ending bar (sum of Budget for all accounts) with multiple bars for variance bridging the Actual and Budget.
Bridging bars (variance of Actual and Budget at dimension account) is plotted perfectly using offset.
I often use waterfall chart which are the most accurate point of view for "evolutions", meanings budget to realized or Past year/ YTD.
As said by Dennis, you must use offset possibilities.
Each must be expressions, without dimensions:
First bridging bar
scd bridging bar
At your disposal for help.