2
Step 3
Enter your data (labels and numbers/percent’s) in the Excel window that opens and then close out of the window by
selecting the “red X” in the upper right corner of the window. Note: You have the ability to resize the data chart range
by adjusting the blue range line (drag the right corner to desired size).
Notes for data entry:
• Category = what you are examining/studying. It could be:
o Time points (quarters, months, weeks, days, etc.)
o Reasons why something occurred (reasons families use the ER, reasons families missed their scheduled
home visits, etc.)
o Etc.
• Series = what you are comparing. It could be:
o Your program’s data compared to the learning collaborative data
o Your program’s data broken down by prior to the improvement and following the improvement
o Your programs data broken down by quarter
o Etc.
Step 4
Edit your chart as needed. Here are some items you may want to consider:
• Add a title
• Add labels to your x and y axis’
• Add data labels to your bars
• Move or remove the key, if needed