In the clustered column chart in the range $J4$:$P18,$ Yuki wants to show the expenses by type, not by month. He also wants to make the contents of the chart clearer. Provide this information for him as follows:

a$.$ Switch the rows and columns to display expenses by type.

b$.$ Display the legend at the top of the chart.

c$.$ Add Expense Amounts as the primary vertical axis title.

d$.$ Add Portland Monthly Expenses as the chart title.

e$.$ Change the fill color of the April data series to Green, Accent $4.$

f$.$ Add a chart border using the Blue, Accent $2$ shape outline color.

Yuki wants to include a chart showing the monthly profits for the Portland office to determine which months have been more favorable. Create a new chart as follows:

a$.$ Create a doughnut chart based on the range C$22$:F$23.$

b$.$ Resize and reposition the chart so that its upper$-$left corner is within cell $J21$ and its lower$-$right corner is within cell P$34.$

c$.$ Enter Quarter $1$ Prffit as the chart title.

d$.$ Apply Layout $1$ to the chart to display percentages on each part of the doughnut and no legend.

Yuki also wants to include a chart showing the revenue earned.from auto, home, and$-$life insurance policies. Create and format a chart for him as follows:

a$.$ Create a Stacked Column chart based on the range B$5$:F$8.$

b$.$ Move the chart to a new sheet, using Quarter $1$ Income as the name of the new sheet.

c$.$ Change the chart style to Style $7$ to match the column chart on the Portland Office worksheet.

d$.$ Change the font size of all the chart text to $12$ point to make it easier to read.

e$.$ Remove the chart title since the sheet tab indicates the purpose of the chart.