Update the Park Spending $2018-2021$ combo chart in the range A$40$:G$56$ as follows:

a$.$ Move the chart to the Projection worksheet.

b$.$ Resize and reposition the chart so that the upper$-$left corner is located within cell A$4$ and the lower$-$right corner is located within cell K$22.$

For the Park Spending $2018-2021$ combo chart, update the chart area as follows:

a$.$ Apply the Monochromatic Palette $4$ color scheme to the chart.

b$.$ Add a secondary axis for the Total series. $[$Mac Hint: Select the Total series and use the format pane to add the axis.$]$

c$.$ Add Axis Titles to the chart, and then enter Spending per park as the left vertical axis title, and then enter Total spending as the right vertical axis title. I Finally, delete the horizontal axis title placeholder.

Gudrun wants to compare future payments for three different scenarios for a park's bond offering. Switch to the Bond Offering worksheet. She has already entered formulas in the range B$9$:D$10$ to calculate the quarterly and annual payments for each option.

In the range E$9$:E$10,$ add Column sparklines using the data in the range B$9$:D$10.$ Ungroup the sparklines, and then set the vertical axis maximum value to $-15000$ for cell $E9$ and to $-60000$ for cell $E10.$

Gudrun wants a clustered column chart comparing the costs of the bond options.

a$.$ Create a Clustered Column chart based on the values in the range A$9$:D$10.$

b$.$ Resize and reposition the chart so that the upper$-$left corner is located within cell A$11$ and the lower$-$right corner is located within call D$28.$

Customize the chart in the range A$11$:D$28$ as follows:

a$.$ Enter Bond Offering Cost Comparison as the chart title.

b$.$ Add Data Labels to the chart.