Hi, I need help with a stacked bar chart with negative figures.
I can't give you specific details on what it's
for, but the scenario is something like this
We are given a budget to work around. Thus, we allocated the budget
around as we saw fit.(Hypothetically, let's say category 1 uses $1000, category 2 uses $2000, and category 3 uses $3000).
However, we found out we used more in some areas, and less in others (Hypothetically, category 1 uses $1250, category
2 uses $1500, and category 3 uses $3500).
My boss wants me to find out the discrpency between the amount
originally planned and the amount that is actually been used, broken down for each individual section (Which mean that,
hypothetically, category 1 has +$250, category 2 has -$500, and category 3 has +$500).
Now, he wants me to combine
all the data into a single chart. For those with purely positive numbers, it is easy enough, but for those with negative
numbers, the graph didn't work out how I imagined it to be.
My plan was to put the original planned amount and the
discrepency in the primary axis and the actual amount used in the secondary axis(with an invisible fill but a thick border to
indicate the amount actually used). Thus, if the actual amount is more than the planned amount, it would appear such that the
border envelops both the planned amount and the discrepency, but if the actual amount is less than the planned amount, the
border would only cover a portion of the planned amount, with the discrepency being tacked on where the border left off.
Is there any way to create the chart in the way that I had imagined? If not, is there a system that could give me the
same effect? I tried looking at a waterfall chart, but it appears that I need a lot of graphs, one for each different
category, and my boss does not want that.
Any help would be appreciated. Thanks.
Also, I apologise if
this section is not where I should post ths question.