fives Excel $365/2021|$ Module $4$: SAM Project la

Customize the chart in the range G$21$:$039$ as follows:

a$.$ Enter $2024$ Park Spending as Percentage of Total as the chart title.

b$.$ Apply Style $3$ to the chart.

Gudrun wants a stacked bar chart showing spending per park for each year.

a$.$ Create a Stacked Bar chart based on the data in the range A$4$:E$9.$

b$.$ Resize and reposition the chart so that the upper$-$left corner is located $n$ A$11$ and the lower$-$right corner is located within cell F$39.$

Customize the chart in the range A$11$:F$39$ as follows:

a$.$ Enter Spending per Park $2021-2024$ as the chart title.

b$.$ Change the Maximum value to $$2,300,000$ on the horizontal axis.

c$.$ Apply a shape fill of White, Background $1,$ Darker $5\%(1$st column, $2$ the Theme Colors palette$)$ to the chart area.

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

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

b$.$ Resize and reposition the chart so that the upper$-$left corner is located $n$

Page $2$ of $5,868$ words