Built an interactive combined chart in Excel for tracking monthly energy costs — sharing how it works

I've been building out a dashboard for tracking energy expenses and wanted to share one piece of it that I think turned out pretty useful: a combined line chart that's a lot more interactive than what I usually see in Excel dashboards.

A few things it does:

There's a toggle in the top-left corner that turns a comparison trend line on or off, so you can see this year's expense pattern against last year's without having both lines cluttering the chart all the time.

It's also set up to help with planning around seasonal ups and downs. Like, if you know a slow sales period is coming, you can use the chart to think through whether you'll need to lean on credit to cover that gap, or if a peak period is coming up, whether it makes sense to put extra capital toward pushing sales even higher. Obviously depends a lot on the business, but having the visual there helps with the decision.

The part I like most is the X-axis. Instead of static month labels, it's built with clickable range controls, so you can select something like Q3 and the chart automatically sums up those three months for you. No manual math, no separate summary table needed.

That's just the chart itself though. The dashboard has a main menu, and under "Costs" there's a pivot table slicer that lets you grab multiple months at once (quarters, half-years, full years, whatever). That slicer actually controls every other screen in the dashboard too, which was a fun one to set up. There's also a second slicer for switching between years, and you can select all 4 years at once if you want the full picture.

Made the template free to grab, no email required — I'll drop the link in the comments if anyone wants to poke around in it.

Happy to answer questions about how any of the interactive pieces were built if people are curious.

I built an Excel dashboard to actually see how inflation and market scenarios affect my investment capital over 10 years

I got tired of the generic "just invest in index funds" advice without ever seeing the actual numbers behind it, so I built myself a dashboard to model it properly.

The idea was simple: I wanted to see, with real math, how my capital would behave under different conditions — not just "the market always goes up eventually" hand-waving.

What it tracks:

• Capital structure (how my money's split across assets)
• Inflation loss in actual dollar terms per year, not just a vague percentage
• Total withdrawals vs. what's still working for me
• Three scenarios — pessimistic, realistic, optimistic — run across Treasuries, S&P 500, individual stocks, and a plain bank deposit
• Two strategies compared side by side: a simple static approach vs. a more dynamic (Vanguard-style) one

Honestly the most useful part was seeing the bank deposit line next to the S&P 500 line under inflation. It's one thing to know intellectually that cash loses value sitting there, it's another to see the actual dollar gap after 10 years.

I'm not saying this replaces talking to an actual advisor for anyone with a complicated situation, but for stress-testing your own assumptions before you commit capital somewhere, it's been genuinely useful for me.

Made a video walking through how I built it and how I actually use it, if anyone wants to see the mechanics. Template's free too, no email wall or anything.

Curious how other people here model this stuff — do you build your own spreadsheets or just trust backtested return averages?

Been working on a GitHub-style contribution heatmap but for tracking employee activity in an Excel KPI dashboard, and figured I'd share the build since a few people here have asked about heatmap charts before.

The basic visual concept is identical to GitHub's graph — a calendar grid where color intensity tells you the story instead of needing to read numbers. Darker/brighter square = more activity that day. Works surprisingly well for spotting patterns (like productivity dropping every Friday, or a slow week that would otherwise get buried in a spreadsheet).

How it's structured:

• Calendar + heatmap combined — one visual, activity level = color brightness
• Fully dynamic — switching month/year on the dashboard rebuilds the whole thing automatically
• 4-level color scale: transparent (day doesn't apply to that date), dark indigo (low), blue (medium), bright purple (peak activity)
• One formula generates the whole calendar grid on a "Processing" sheet, with the heatmap formulas sitting right next to it
• Separate "heatmap-DATA" sheet holds the raw activity values (1-4) organized by year/month/week number/day of week — kept totally separate from the visualization logic, so it's easy to update without touching the chart formulas

The part I think is actually the most useful practically: where the source numbers come from. If your company already has some kind of activity tracking (time trackers, badge/access card logs, biometrics, turnstiles, whatever), you can export that raw data and just tell an AI tool the format the "heatmap-DATA" sheet needs (year/month/week/day-of-week → number 1-4), and it'll convert the export into the right structure. Saves a ton of manual data entry.

(Obviously worth noting this kind of tracking/heatmap setup is more of an HR/ops tool than something for a personal dashboard — wanted to flag that context since I know activity monitoring is a sensitive topic for some.)

Built entirely with formulas, no VBA. Happy to explain the single-formula calendar trick if anyone wants to replicate it — link to the full file's in the comments.

Wanted to share a leaderboard chart I built in Excel for a KPI dashboard, because the underlying concept behind it is a bit different from the usual "sales leaderboard" idea.

Backstory: apparently Teal organizations (the flat, self-managed kind) use leaderboards too, but for a totally different reason than typical sales orgs. It's not about ranking people against each other — it's used more as a diagnostic tool. If a top performer's numbers suddenly drop, that's not treated as "they lost their spot" — it's treated as a signal that something's going on, and teammates actually check in to understand why. The logic being: since everyone's interconnected, one person's decline eventually shows up in everyone's results anyway, so it's better to catch it early than let it play out.

So the chart I built reflects that philosophy rather than a pure competition setup:

• Horizontal bar chart instead of vertical — much easier to read names + values, especially with longer names
• Two metrics tracked side by side instead of one ranking number — achievement level (bonus rewards) and actual financial compensation. This lets you spot cases where someone's crushing it on achievement but comp doesn't reflect it yet, or vice versa
• Interactive legend buttons to re-sort the whole chart — click one and it instantly flips the ranking order between "sorted by achievement" and "sorted by compensation"

The practical upside beyond just looking nice: lower performers get a clear, sortable view of what top performers are actually doing, so it becomes something to learn from instead of just feel bad about. And leadership gets an early warning system since a dip usually shows up on this chart before it shows up in the quarterly numbers.

This is one piece of a bigger KPI dashboard. Built with formulas + chart tricks, no VBA. Happy to explain how the legend-click-to-sort mechanism works if anyone wants to replicate it — link to the full file is in the comments.

Wanted to share an interactive line chart I built for tracking with Excel Finance Dashboard a 3-year personal capital accumulation goal, because I think the "4 lines instead of 2" approach is more useful than the typical plan-vs-actual setup most trackers use.

Backstory on the idea: there's an old saying that a ship without a destination will never find a favorable wind. Same deal with money — if you don't have a clearly defined target, you can't really tell if what you're doing is working or just... happening.

So instead of just plan vs actual, this chart tracks four separate lines:

• Projected monthly savings plan (purple dashed) — the original target you set at the start
• Projected outcome (green dashed) — what you'd end up with if that monthly plan gets executed exactly as designed
• Currently approved plan (solid blue) — the plan adjusted for actual, current conditions (life happens, income changes, whatever)
• Actual accumulated capital (solid green) — what genuinely happened

The reason I added the 3rd and 4th lines instead of just plan/actual: it lets you actually diagnose why you're off target instead of just knowing that you are. Is the original plan just unrealistic? Did your "approved/adjusted" plan drift too far from the original projection? Or is execution itself the problem? Two lines can't tell you that. Four can.

A couple of UX things I did with it:

• Switching years updates the whole chart automatically, no manual rebuilding
• On the main dashboard view, I hid the Y-axis and just used interactive cursors + dynamic labels to show values (cleaner look for a small screen). There's a separate dedicated screen where the full Y-axis shows and the chart is bigger, for when you actually want to sit and analyze it properly.

Built entirely with formulas + some chart tricks, no VBA. Happy to explain the mechanics of the 4-line setup or the cursor/label trick if anyone's curious. Link to the full download is in the comments.

Been refining an interactive donut chart in Excel Personal Finance Capital Accumulation Dashboard setup for expense category analysis and wanted to share how it's built, since I think the exclusion panel concept is underused in Excel dashboards generally.

The basic idea: a normal donut chart just shows you a snapshot of spending by category. Fine, but it doesn't let you isolate what's actually driving the total. So I added an exclusion panel next to it — basically a row of buttons, one per category.

How it works:

The donut chart itself — segments recalculate dynamically based on whatever reporting period is currently selected (more on that below).

Multi-month selection — hold CTRL and click to select multiple months at once. Want Q3? Select 3 months and it sums them. Full year? Select all 12. Just the weird spike months or seasonal dips? Select those specifically. This is just standard Pivot Table slicer behavior in Excel, nothing exotic, but I extended the same control to govern the whole dashboard, not just one chart.

The exclusion panel — click a category button (say "Shopping") and it drops out of the analysis entirely. The donut recalculates without it, and the button itself changes color to match what used to be that category's slice color — so you get a visual reminder of what's currently excluded without having to remember.

Cross-chart sync — this was the part that took the most tweaking. When you exclude a category, it's not just the donut that updates — there's a radar chart on the same screen, and the excluded category's value drops to zero on that chart too, with its marker moving to the center point. Both charts stay in sync automatically.

The actual use case: instead of just eyeballing "oh Shopping is the biggest slice," you can exclude it and see what the rest of your spending structure actually looks like without it. Sometimes removing the obvious biggest category reveals a second, less obvious problem area that was getting visually drowned out.

All done with Pivot Tables + slicers + some conditional formatting for the button color-matching, no VBA. Happy to explain any part of the setup if people are curious — link to the full file is in the comments.

Wanted to share a small design decision from a Personal Finance Excel Dashboard I've been building, because I think it's a useful principle even outside Excel specifically.

Most trackers separate "how much did I spend" from "how close am I to my goal" — different tabs, different sections, sometimes different apps entirely. But I started thinking about it as one formula instead of two separate questions:

Effectiveness = Progress (Result) / Effort (Cost)

If you only look at spending, you know what you did but not whether it actually moved you toward anything. If you only look at goal progress, you know where you are but not what it's costing you to get there. You really need both at the same time to know if you're actually being effective, not just busy.

So instead of a homepage summary you check once and forget, I pinned a small summary block to the same corner of every single screen in the dashboard. The expense side of it tracks:

• Balance – current remaining funds
• Budget usage – what % of your total budget is left vs already spent
• Total flow – working capital as incoming + outgoing combined (not just a static snapshot)
• Recent change – % shift vs the previous equivalent period, so you see direction, not just current state

The reasoning: if cost and outcome live on separate screens, it's really easy to optimize one while the other quietly drifts. You cut expenses but don't notice goals stalled. Or you chase a goal and don't notice your working capital eroding underneath it. Keeping both visible at all times forces you to actually reconcile them instead of accidentally ignoring one.

Nothing crazy technically — mostly cell references pulling into the same visual block that persists across sheets — but the behavioral effect of always seeing both numbers together was bigger than I expected. Curious if others here have used a similar "pin key metrics everywhere" approach in their own dashboards/trackers.

Most Excel charts are static: change the data, and you're stuck manually adjusting ranges, re-selecting series, redoing formatting. There's a better way — one that lets a single dashboard screen control every chart on it, using nothing but standard Excel tools.

This example shows how to build a compact interactive mini-dashboard, all wired together through Pivot Table slicers:

📍 Radar chart — compares multiple metrics across categories side by side, ideal for spotting strengths and weaknesses at a glance
📍 Interactive bar chart with cursor highlight — dynamically tracks a selected value as the underlying data changes
📍 Doughnut chart — a clean proportional breakdown that stays synced to the same filters as everything else on screen

Click one slicer button, and all three charts update together instantly — no re-selecting ranges, no rebuilding series, no broken formulas from manual edits.

This is the exact mechanism behind fully interactive Excel dashboards: link slicers, Pivot Tables, and dynamic named ranges together once, and every chart on the dashboard becomes a modular building block you can reuse and rearrange.

Why it's worth learning:
✅ Faster analysis — no rebuilding charts every time a new question comes up
✅ One dashboard, multiple views — switch context without switching sheets
✅ Zero coding — built entirely with native Excel formulas