1. Monthly Profit Analysis
Financial AnalystBackground
The analyst needs to present a monthly profit report to stakeholders, showing how revenue and various expenses lead to the final net profit.
Problem
Standard bar charts do not clearly show the cumulative impact of expenses on the starting revenue.
How to use
Input the revenue and expense items into the Data Items field, marking the starting revenue and final net profit as subtotals.
[{"label": "Starting Revenue", "value": 5000, "isSubtotal": true}, {"label": "Sales", "value": 2000}, {"label": "Rent", "value": -1000}, {"label": "Salaries", "value": -1500}, {"label": "Net Profit", "value": 4500, "isSubtotal": true}]Outcome
A clear waterfall chart showing the progression from 5000 to 4500, with expenses highlighted in red and revenue in blue.