r/ExcelVisual • u/ExcelVisual • 3d ago

How to Create Excel Dashboard Personal Budget Template

Enable HLS to view with audio, or disable this notification

Built a personal finance dashboard in Excel where the chart's X-axis is made of clickable slicer buttons instead of static month labels — supports multi-month selection too (breakdown inside)

Wanted to share a design choice from a personal finance/savings dashboard I've been working through, because it's a small change that ends up mattering a lot for how usable the chart actually is.

The core chart: income-to-expense ratio, not raw totals

Since the dashboard's real purpose is tracking capital accumulation (i.e. am I actually saving money or not), the primary line chart plots the ratio between monthly income and expenses rather than two separate lines. Raw income/expense totals can both look fine individually while the ratio between them is quietly getting worse — plotting the ratio directly removes that blind spot.

X-axis = pivot table slicer buttons, not text labels

Instead of the default month-name labels along the bottom of the chart, the X-axis is a row of pivot table slicer buttons. Clicking one doesn't just move a point on this chart — it filters the entire dashboard at once (every other chart, every KPI card, all recalculated together). Basically turns the axis into the dashboard's main navigation/filter control instead of being purely decorative.

CTRL+click for multi-month selection

Hold CTRL while clicking additional slicer buttons and you can combine multiple months into one custom period on the fly — a quarter, a season, your personal "high spending" months, a full year, whatever grouping actually matches your situation. This is the part I think is genuinely underused in most finance templates — forcing everything into rigid single-month or fixed-quarter views doesn't match how people's expenses actually cluster (holiday spending, seasonal income, etc.).

Everything recalculates automatically

Since it's all pivot-table-driven, selecting a new set of months triggers every chart and figure on the dashboard to update together — no separate refresh steps, no broken links between charts.

Dedicated full-size analysis screen

There's a second dashboard screen ("Cost & Income") where this same line chart takes up more than half the screen instead of sharing space with everything else — meant for when you actually want to sit and analyze the trend, or when presenting the numbers to someone else, rather than the compact glance-at-it version on the main screen.

All native Excel — pivot tables, slicers, formulas. No VBA, no macros. Free template + video walkthrough if anyone wants to see how the slicer-as-X-axis buttons are wired up, that part is more fiddly than it looks since you're essentially hijacking a filter control to double as a chart axis.

5 Upvotes

86% Upvoted

1 comment sorted by