This file contains four templates, in which I have visualized revenue and expenses data as: 1) two pie charts; 2) bar charts; 3) bar charts with a text box where you can add explanatory text like totals; and 4) a dashboard template.
In the dashboard, type your numbers into the Q1-Q4 cells and the trendlines, year-end totals, and year-end bar charts will automatically update themselves. You'll probably want to change the generic Revenue Source A and Revenue Source B language into your actual categories. You can also change the name from Financial Dashboard into the title of your choosing and you can change the Date placeholder into the date of your choosing.
If you choose to download these materials, you'll be added to my mailing list. You can unsubscribe at any time, but I hope you'll stick around. I share data tricks every week or so.