Has anyone found a good way to visually display daily metrics for the month?

aweber

I work in manufacturing and I am trying to build a dashboard for our tiered meetings. I know some people might be familiar with what I am building as it is common in the industry. I have several sheets where Safety incidents and quality incidents etc. can be submitted. My management wants me to build a dashboard that will display metrics in a calendar format (green day for no incidents, yellow for 1, and red for >1). I have data in the sheets and dates when incidents occurred. I just need a way to display them by month on the dashboard. Has anyone found a good way to do this?

The only way I have found to do this would be to build the calendar in a separate sheet and pull in metrics to each day but that would require me to remake the sheet each month. Is there a better way to do this that I am not thinking of?

Matt Lynn ACT

@aweber Good question. I've done things like this in manufacturing also, but probably not an actual calendar just because it takes up more real estate with less info for the area. I usually do a bar chart with a bar (or line) per month which would communicate the same thing in about 1/5 the real estate. I would also make this a dynamic chart so it changes as the months progress rather than having it static and requiring frequent updates.