Guided Notes
Charts & Simple Reports in Excel
Choose the right chart for healthcare data, build trend and comparison charts, add targets, avoid misleading visuals, and assemble a one-page monthly report.
Pick the right chart
Slide 1 / 5| Question | Chart |
|---|---|
| How does it change over time? | Line chart (with target line) |
| How do groups compare? | Bar chart (sorted) |
| What is the composition? | Stacked bar or 100% stacked bar (avoid many-slice pies) |
| How is it distributed? | Histogram (LOS, wait times) |
| Is there a relationship? | Scatter plot (age vs cost) |
| Is the process stable? | Run/control chart |