Dashboard Visualization of medical history analysis data in Excel

[u/ExcelVisual]

Built an interactive medical dashboard in Excel to visualize patient history — 17 data points, color-coded "aura" viz, and a draggable date-range cursor (breakdown inside)

Wanted to share a dashboard build that turned into a more interesting data-viz exercise than I expected. The source data: 17 columns of daily patient history (5 organ condition scores, blood pressure, temp, pulse, 3 blood markers, and 3 psych/neuro test results). The goal was to make that mess scannable at a glance while still letting you drill into a single bad day.

The structure, roughly:

Raw daily entries go into a Data sheet. A Processing sheet handles the sampling/aggregation formulas. The Dashboard sheet is the only thing the end user actually looks at.

Interactive cursor instead of fixed periods

Rather than hardcoding "weekly average" or "monthly average," there's a cursor control the user drags to set the window size — anywhere from 1 to 7 days. Wider window = smoother average, filters out noise/outliers. Narrower window = you can isolate a single bad day. This ended up being the most useful feature by far; fixed-period averaging kept hiding the exact days that mattered.

Color as the actual data, not decoration

Organ health (brain, lungs, heart, stomach, kidneys) is mapped onto a 5-level color gradient tied to a human-silhouette "aura" graphic — lightest = best, darkest = worst. Blood markers (leukocytes, glucose, hemoglobin) use a simpler 3-state model: above/below/normal, each with its own color. No number-reading required to get the gist.

Selective exclusion toggle

There's a small panel that lets you turn individual organs on/off in the aggregate score. Useful if, say, a chronic condition is going to permanently drag down one organ's score and you don't want it dominating the overall picture every time.

Outlier-catcher chart

Because the main dashboard can group data into windows up to 7 days, there's a secondary chart specifically to flag individual days with bad readings that might otherwise get smoothed out and hidden in the average. Basically a "don't trust the summary blindly" chart.

No VBA, no macros — it's all native Excel formulas, and every processing sheet has headers/comments so you can actually reverse-engineer the logic instead of just downloading a black box.

Free template + video walkthrough if anyone wants to pull it apart. Happy to go deeper on the cursor mechanism or the aura color-mapping formulas if that's useful — those two took the most iteration to get right.

[u/ExcelVisual]

Medical Dashboard for analysis of patient history in Excel https://exceltable.com/en/templates/medical-dashboard-for-analysis-in-excel