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 purbose of the chart.

X Insert a chart.

The workbook should contain a worksheet named "Quarter $1$ Income".

X Move a chart to a chart sheet.

The workbook should contain a worksheet named "Quarter $1$ Income".

X Change the chart style.

The workbook should contain a worksheet named "Quarter $1$ Income".

X Change the size of text in vertical and horizontal axes.

The workbook should contain a worksheet named "Quarter $1$ Income".

X Remove a chart title.

The workbook should contain a worksheet named "Quarter $1$ Income".

Clarify the data in the chart as follows:

a$.$ Format the values in the vertical axis using the Accounting number format with no decimal places

to clarify the values are dollar amounts.

b$.$ Add the default data labels to the chart to display the revenue values.

c$.$ Remove the legend to allow more room for the chart data.

X Change the number format of the vertical axis text.

The workbook should contain a worksheet named "Quarter $1$ Income".

X Add a data label to a chart data point.

The workbook should contain a worksheet named "Quarter $1$ Income".

X Remove a legend from a chart.

The workbook should contain a worksheet named "Quarter $1$ Income".