Llang wants to include summary statistics about the project and the team members. Include this information as follows:
In cell E17, enter a formula that uses the AVERAGE function to average the number of years of experience (range N5:N14).
Make the Line chart in the range C19:133 easier to interpret as follows:
a. Change the chart type to a Clustered Column chart.
Enter Task Progress as the chart title.
C. Add a primary vertical axis title to the chart, entering Hours as the axis title text.
d. Add data labels to the Outside End of each column.
In cell E17, enter the formula "=AVERAGE(N5:N14)" to calculate the average number of years of experience for the team members.
To make the Line chart in the range C19:133 easier to interpret, follow these steps:
a. Select the chart and go to the "Design" tab in the Excel ribbon. Then click on the "Change Chart Type" option.
b. In the "Change Chart Type" dialog box, choose the "Clustered Column" chart type and click on "OK".
c. Click on the chart to select it. Then, go to the "Layout" tab in the Excel ribbon and click on "Chart Title". Enter "Task Progress" as the title for the chart.
d. Still on the "Layout" tab, click on "Axis Titles" and select "Primary Vertical Axis Title". Enter "Hours" as the axis title text.
e. Finally, go to the "Layout" tab and click on "Data Labels". Choose the "Outside End" option to add data labels to the end of each column, making the chart easier to interpret.