Grouped Bar for YoY Revenue Comparison — Prior Year vs Plan vs Actual
A Year-over-Year (YoY) grouped bar chart clusters Prior Year ($Y_{t-1}$), Budget Plan ($Y_{plan}$), and Current Actual ($Y_t$) columns for each division to evaluate both YoY growth and budget attainment.
Tip: Paste Excel or Google Sheets rows (Ctrl+V / ⌘V) directly into any cell.
| # | Label | ||||
|---|---|---|---|---|---|
| 1 | |||||
| 2 | |||||
| 3 | |||||
| 4 | |||||
| 5 | |||||
| 6 |
YoY Growth % = ((FY26_Actual - FY25_Actual) / FY25_Actual) * 100%. Budget Attainment % = (FY26_Actual / FY26_Budget) * 100%.
Chart Design & Use-Case Tips
- 01YoY Growth % = ((FY26_Actual - FY25_Actual) / FY25_Actual) * 100%. Budget Attainment % = (FY26_Actual / FY26_Budget) * 100%.
- 02Comparing all three bars per cluster answers the two questions every CFO asks: 'Did we grow vs. last year?' (Series C vs. Series A) and 'Did we beat our budget plan?' (Series C vs. Series B).
- 03Enable Data Labels to print exact dollar figures above each column.
- 04Export as 300-DPI PNG or Vector SVG for quarterly business reviews (QBRs).
Frequently Asked Questions
Why put Prior Year on the left, Budget in the middle, and Actual on the right?+
Left-to-right chronological ordering (Past -> Plan -> Present Result) lets the eye follow a natural upward staircase whenever a division beats its plan.
How can I compare just FY 2025 vs. FY 2026 (2 bars per group)?+
Clear or zero out the third column (Series C) in the Data Workbench and the chart automatically renders clean 2-bar pairs.
Can I copy the table into Excel after editing?+
Yes, click 'Copy CSV Data' to copy all rows and columns straight to your clipboard.