Question: For the Park Spending 2 0 2 1 - 2 0 2 4 combo chart, update the chart area as follows: uarr a . Apply

For the Park Spending 2021-2024 combo chart, update the chart area as follows: uarr
a. Apply the Monochromatic Palette 4-color scheme to the chart. I use the format pane to add the axis.] In
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. Finally, delete*the*horizontal saxis*title*placeholder. In '
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*B9:D10 to calculate the quarterly and annual payments for each option.
In the range E9:E10, add Column sparklines using the data in the range*B9:D10. Ungroup the sparklines, and then set the vertical axis maximum value to -15000 for cell
Gudrun wants a clustered column chart comparing the costs of the bond options. I
a. Create*a Clustered Column chart based on the values in the range*A9:D10. I
b. Resize and reposition the chart so that the upper-left corner is located within cell * A11 and the lower-right corner is *ocated within cell-D28. II
Customize the chart in the range*A11:D28-as*follows: ||
a. Enter*Bond-Offering Cost-Comparison as the chart*title.
b. Add * Data:Labels to the chart.
I
 For the Park Spending 2021-2024 combo chart, update the chart area

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!