Morning all,
Ok so I am working on a project in which I am visualizing contract costs or better said the liability of costs for an organization. What I can't figure out is how to layer three bar charts on top of each other, where each start at zero. Almost like a duel axis but with three to four amounts.
Example - a contract has three amounts:
1. Committed - amount which is the amount they are budgeting to paying (before agreement).
2. Obligated - amount legally obligated to pay (agreed amount to pay).
3. Expended - amount they have spent to meet the obligation.
What I need to show is the sum amounts of each of these YTD. At the lowest "layer" you would have the committed amount, then the obligated amount laid on top of that, then the expended amount laid on top of that. What I don't want is a stacked bar chart.
This way a manager can see the various amount through the various stages of a contract's life as money is applied and it cycles through its various stages.
That said, I am open to other ideas that you have and that might work.
Scott- I deal with these type of requests everyday, and simplest way of showing "Current vs Actual vs Budgeted" sales is something like,
This is my color standard,
Current - I show in Blue
Prior Year - Orange
Budget - Reference Line in Red
Good Luck!
Best,
Shiva.
