Forum Discussion
Waterfall Chart with starting value
I have a query which contains data for a number of companies (for argument's sake let's call them CompanyA to CompanyG). The query contains a separate record for each comapny for each week.
Two of the columns that are stored against each record are Budget and BudgetVariance.
I am required to create a waterfall chart for each week that has the sum of budget for all companies as a starting value then displays the variance for each company with the total variance as the final column (hope this makes sense).
I can show the variance on the Y-axis, my issue is how can I display the total budget as the starting value, I can't see any way to add a starting value to the waterfall chart.
1 Reply
I'm trying to understand your requirements...
What I've done in the past to make custom waterfalls is create calculated tables, so that the sum of budget shows first on the X-Axis, then followed by each of the company names with sum of budget variance, then a grand total.
I often used a stacked bar chart.
