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
QuestionChart
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
← PivotTables & Summary Reports