Instructions NP EX16,4a (1) (Protected View) Word Signin B Home Insert Design Layout References Mailings Review View Help Tell me what you want to do Enable Editing OTECTED VIEW Be careful-files from the internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View 2 B. 9 The data de su use Percentage We Update the Total Annual Income: 2019-2024 line chart in the range A11:126 by editing the Horizontal (Category) Axis labels to display using the values in the range 4:04 In the line chart, modify the Minimum bounds of the vertical axis to be 150000. 10. Format the line chart as described below: Update the line chart by adding Primary Major Horizontal gridlines and Primary Major Vertical gridlines to the chart area a. Apply a solid fill using the Blue, Accent 5, Lighter 80% fill color to the chart area. b Apply the Arial font and the Blue, Accent 5 font color to the chart title. 11. Casey created a stacked column chart to show how the income generated by each membership package contributed to the total annual income. He now needs to modify the data and formatting used in the chart. Update the Package Contribution to Annual Income: 2019-2024 stacked column chart (in the range A27:144) by removing the stata series labeled "Total" from the chart (Me Do not filter out or hide the data) 12. In the stacked column shart, format the chart legend as described blow Apply Shape Fill using the White, Background 1 fill color b Apply a Solid Line border with a Blue, Accent 1 border color. E Apply Shadow Shape Effect from the Outer section using the Offset Diagonal Bottom Right option (on Depending on your season of off, this may be day as "Offset: Bottom Night") 12. For his loan application, Casey needs to create a chart that displays both the annual income generated by each membership package and Inception worn totaal Decause of the large difference between the package income and total income values, Casey determines that a combe chart is minst appropriate optron Select the range A4 10 and oats a Custom Combination Combo chart as described til Represent the following data se plant the Total data is Figure 1: Combo Chart Setup as a Clustered Column chert Open Desk Visitar, Open Desk Hegular. Dedicated Desk Dedicated Office and Penting m a Line charting the Sandary Aals as shoes four d Search foring C 9 DOLL