Illustrated Excel $2019|$ Module $4$: SAM Project $1$b

Move the chart legend to the Left position to provide more room for the data.

Grace can see that Quarter $2$ was the most profitable quarter of the year at $29\%.$

Explode the largest slice of the pie $($representing Quarter $2)$ by $10\%.$

Go to the New Services worksheet. The clustered column chart in this worksheet shows

how the Oakland revenue has changed over four quarters.

Resize and reposition the clustered column chart so that its upper$-$left corner is within

cell $H3$ and its lower$-$right corner is within cell $N17.$

Identify the purpose of the clustered column chart by entering Quarterly Revenue as

the chart title.

Change the chart colors to Monochromatic Palette $2(2$nd in the Monochromatic

palette in the Change Colors menu$)$ to coordinate with the other colors in the worksheet.

Change the fill color of the data series representing the Security plan to Dark Red,

Accent $2,$ Lighter $40\%(6$th column, $4$th row in the Theme Colors palette$)$ to contrast

with the other data series.

Apply the Accounting number format to the range B$5$:F$7,$ and decrease the number of

decimal places shown to zero to change the format of the values in the vertical axis of

the clustered column chart.

Grace wants to create a chart that tracks the changes in the profit amounts from one

quarter to another. Create a new chart as follows:

a$.$ Create a Line with Markers chart based on the range B$20$:E$21.$

b$.$ Enter Quarterly Profit as the chart title.

c$.$ Resize and reposition the chart so that its upper$-$left corner is within cell $H19$ and

its lower$-$right corner is within cell N$32.$

Your workbook should look like the Final Figures on the following pages. Save your changes,

close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your

completed project.