In this project, you will analyze employee evaluations in your department. As manager, you evaluated employees on five criteria: Productivity, Work Quality, Initiative, Working Relations, and Writing Skills. You have rated each employee with a score of 1 to 5. You need to create charts and insert Sparklines to depict the data visually.
For the purpose of grading the project you are required to perform the following tasks:
Start Excel. Open the downloaded Excel file namedexploring_e03_grader_a1.xlsx.
Select the range B4:F8 (the employee ratings) and create a column sparkline in the range H4:H8.
Apply the Sparkline Style Accent 1, Darker 50% style to the sparklines.
Show the High Point. Apply Dark Red as the marker color for the Low Point.
Change the row height to 25.00 for rows 4 through 8.
Select the range A3:F8 and create a clustered bar chart. Position the chart in the range A12:G40.
Apply Style 12 chart style.
Type 2016 Employee Evaluations by Category as the chart title. Apply Blue, Accent 5, Darker 25% font color to the chart title.
Change the Maximum Bounds for the value axis to 5.0.
Select the ranges A3:A8 and G3:G8, create a clustered column chart, and move this chart to a new chart sheet named Overall Evaluations.