Shelly Cashman Excel $2019|$ Module $3$: SAM Project la

$14.$ Lindsey also wants to compare the estimated sales of July and December. Insert a chart that provides this information as follows:

a$.$ Create a Clustered Column chart based on the nonadjacent ranges A$22$:B$26$ and G$22$:G$26.$

b$.$ Enter Estimated Sales: July and December as the chart title.

c$.$ Resize and reposition the chart so its upper$-$left corner is in cell A$35$ and its lowerright corner is in cell E$49.$

d$.$ Change the chart layout to Layout $2$ to display the data values above the bars instead of including a vertical axis.

Your workbook should look like the Final Figures on the following pages. The value in cell B$3$ has been intentionally blurred as it will never be constant. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.