Oracle Analytics and AI

MJC

Hi-I am trying to create a version of a stacked bar chart but I'm not having much luck and wondered if anyone has had success with this. Within each bar I want to show the original budget, the actual expenses against the budget, and the reforecasted (budget amount). For example, if the original budget was $11 M, and the actuals were $8 M, and the reforecast was $10 M, the height of the bar would be $11 M, the actuals would show within that bar up to $8M, and the reforecast would show as $10M within the same bar. A stacked bar chart adds those three together so puts the height at $29M. Has anyone done anything like this successfully?

Jerry Casey

That seems a little misguided, unless the relative magnitude of the 3 values is always the same. I assume your reforecasted budget could be larger or smaller than the original budget. It sounds like you want the height of the stack to be equal to the largest value, with the others superimposed on top of it. There may be more imaginitive ways to display it, but I'd lean towards something like this:

Alternatively, you can do some awkward calculations that show the differences among your 3 values so that they stack up to the correct height.