I want to create a chart with two columns: one column will be my budget, the other column I want stacked to show what I have spent so far and what I expect to spend.
I tried faking it by creating two charts (one for budget, the other for the stacked), but this can cause problems when the sum of what I have spent and what I expect to spend do not equal my budget column. In other words, they don't always adjust appropriately in terms of height.
For a short while, a Treemap looked promising, but the "stacked" side would sometimes go side-by-side instead of stacked.
Can this be done?
I tried faking it by creating two charts (one for budget, the other for the stacked), but this can cause problems when the sum of what I have spent and what I expect to spend do not equal my budget column. In other words, they don't always adjust appropriately in terms of height.
For a short while, a Treemap looked promising, but the "stacked" side would sometimes go side-by-side instead of stacked.
Can this be done?
