Add a pie chart of the shareholder data in the range $A22$:$B24.$ Resize and position the chart to

cover the range A$26$:B$37.$ Do not display a chart title. Add data labels to the pie chart, and then

move the legend to the left edge of the chart area.

In the Income Statement worksheet, create a $3-$D column chart of the income and expenses data

from the last three years in the range A$4$:D$4,$A$7$:D$7,$A$13$:D$13,$A$20$:D$20.$

Move the chart to the range D$6$:$120$ of the Overview worksheet. Change the chart title to Income

and Expenses $($Thousands of Dollars$).$ Remove the chart legend.

Explore $7.$ Double$-$click the horizontal axis values to open the Format Axis pane. Expand the

Axis Options list, and click the Categories in reverse order check box in the Axis position

section to display the year value in reverse order so that $2015$ is listed first.

Explore $8.$ Add the data table chart element with legend keys showing the actual figures used

in the column chart. $($Hint: Use the Chart Elements button to add the data table to the chart, and

use the data table submenu to show the legend keys.$)$

In the Balance Sheet worksheet, create a $3-$D stacked column chart of the data in the range

$A4$:$D4,A7$:$D11$ to show the company's assets over the past three years. Move the chart to the

Overview worksheet covering the range D$21$:$137.$ Change the chart title to Assets $($Thousands of

Dollars$).$ Remove the chart legend.

Explore $10.$ Use the Switch Row$/$Column button in the Data group on the Chart Tools Design

tab to switch the categories used in the chart from the asset categories to the year values. Display

the values on the horizontal axis in reverse order, and add a data table chart element with