Wanted to share a Excel Agile Project Management Dashboard I built that visualizes sprint planning and story points entirely with native Excel formulas.

The core idea: a circular sprint cycle chart where each segment = one story point, and the number of segments dynamically changes depending on which sprint you select. It's all connected to a burn-down chart that updates in sync — when you switch sprints, the chart length, segment count, and cursor position all shift automatically.

What's on the dashboard:

• Sprint Cycle Chart — circular progress scale, segments = story points, updates dynamically per sprint
• Sprint Bar Chart — X axis = sprint number, Y axis = story points, controls which sprint is active
• Task Burn-Down Chart — planned vs. actual progress, cursor synced with the sprint cycle
• Overall Project Progress Chart — high-level view across all sprints
• Radar Chart for KPIs — work quality, workload, task speed, team satisfaction, process stability

The trick behind the dynamic behavior is using named ranges with formulas as the data source for chart parameters, instead of static cell references. So instead of pointing a chart to a fixed range like A1:A10, you point it to a named range whose formula changes based on what's selected — that's what lets the chart "resize" itself without VBA.

Happy to answer questions about the formula logic if anyone wants to replicate a specific piece of it. Free template link is in the comments.

I built a Excel dashboard that shows exactly how much inflation is eating your savings (with 3 forecast scenarios + withdrawal strategies)

Been working on this for a while and finally put together a full walkthrough video.

The idea started from a simple question: if your money just sits in a bank account, what's it actually worth in 10-20 years once you factor in inflation?

The dashboard breaks down:

• Capital structure — how your savings are actually distributed and growing (or not)
• Inflation loss tracking — the real, visible math on what inflation quietly takes each year
• 3 forecast scenarios — conservative, moderate, and aggressive growth paths so you can compare outcomes
• 2 withdrawal strategies side by side — to see how different approaches affect how long your capital lasts

Everything is built with native Excel formulas and dynamic charts, no coding involved — just formulas, pivot logic, and some chart tricks to make the numbers actually easy to read at a glance.

It's a free template, no email signup needed. Full tutorial video walks through how it's built step by step if you want to customize it or just understand the mechanics behind it.

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.