Hi all
Newbie question here... Could I get an opinion on what types of graphs or charts or dashboards could I easily create from Excel from the table below?
The basic premise is that I want to create an executive summary dashboard to show how each staff member is progressing against each other, as well as how they are performing overall.
The table shows activities in the columns for each set of staff certifications. All staff must complete their briefing before undertaking certification (they've all done their briefings to date). The certifications are generally done from 1-5 but it is possible to run them in parallel. Some of the staff only need to do certifications 1-3, while a couple of members need to do certifications 4 and 5 as well.
I've calculated their average progress using a COUNTIF function on the far right column, but would like to create some more impactful visuals for reporting purposes.
Any suggestions on types of charts or graphs would work well to put into a dashboard please, and how I could do this in Excel? I'm assuming I can't generate a dashboard from Excel. I don't have access to PowerBI or other visualisation tools yet so I might have to create the dashboard in Powerpoint to start with, using the outputs from Excel.
Any help would be greatly appreciated! Many thanks in advance.
Newbie question here... Could I get an opinion on what types of graphs or charts or dashboards could I easily create from Excel from the table below?
The basic premise is that I want to create an executive summary dashboard to show how each staff member is progressing against each other, as well as how they are performing overall.
The table shows activities in the columns for each set of staff certifications. All staff must complete their briefing before undertaking certification (they've all done their briefings to date). The certifications are generally done from 1-5 but it is possible to run them in parallel. Some of the staff only need to do certifications 1-3, while a couple of members need to do certifications 4 and 5 as well.
I've calculated their average progress using a COUNTIF function on the far right column, but would like to create some more impactful visuals for reporting purposes.
Any suggestions on types of charts or graphs would work well to put into a dashboard please, and how I could do this in Excel? I'm assuming I can't generate a dashboard from Excel. I don't have access to PowerBI or other visualisation tools yet so I might have to create the dashboard in Powerpoint to start with, using the outputs from Excel.
Any help would be greatly appreciated! Many thanks in advance.
| Book1 | |||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | |||
| 1 | Briefing | Certification 1 | Certification 2 | Certification 3 | Certification 4 | Certification 5 | |||||||||||||||||||
| 2 | Activity 1 | Activity 2 | Activity 3 | Activity 4 | Activity 5 | Activity 6 | Activity 7 | Activity 8 | Activity 9 | Activity 10 | Activity 11 | Activity 12 | Activity 13 | Activity 14 | Activity 15 | Activity 16 | Activity 17 | Activity 18 | Activity 19 | Activity 20 | % complete | ||||
| 3 | Arthur | Yes | Yes | No | No | No | Yes | No | No | No | No | No | No | No | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 23% | ||
| 4 | Betty | Yes | Yes | Yes | No | No | Yes | No | No | No | No | No | No | No | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 31% | ||
| 5 | Claude | Yes | No | No | No | No | Yes | No | No | No | No | No | No | No | Yes | No | No | No | No | No | No | No | 14% | ||
| 6 | Danny | Yes | No | No | No | No | Yes | In prog | No | No | Yes | No | No | No | Yes | No | No | No | No | No | No | No | 19% | ||
| 7 | Enzo | Yes | Yes | Yes | Yes | No | Yes | In prog | No | No | No | No | No | No | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 38% | ||
| 8 | Fabian | Yes | No | No | No | No | No | No | No | No | No | No | No | No | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 8% | ||
| 9 | Gaucho | Yes | Yes | In prog | No | No | No | No | No | No | No | No | No | No | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 15% | ||
Sheet1 | |||||||||||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| W3:W4,W7:W9 | W3 | =COUNTIF(B3:N3,"Yes")/13 |
| W5:W6 | W5 | =COUNTIF(B5:V5,"Yes")/21 |
