2 questions from New Perspectives Excel 2019 | Module 4 - End of Module Project 2
- In the 2021 Revenues by Insurance Type 3-D pie chart (in the range H26:O43), change the legend position to bottom. Add data labels that contain only percentages (not values) and that use the Center position.
- In the Total Revenues by Year 2018-2021 line chart (in the range A11:G28), change the minimum bound of the vertical axis to 2500000, change the major units of the vertical axis to 500000 change the minor units to 250000, and then add Inside tick marks for the minor units on the vertical axis.
krishna asked 2 years ago
Select the chart > double click > in the sidebar the new section will appear as shown in video or click on + sign and select more on any options and new section will appear.
Click on dropdown and select Legeng > click on last icon > choose bottom.
Click on chart > + sign > select data label. From the sidebar or slect + sign > data label > more to get the sidebar, click on dropdown and choose data Series 1 Data Labels > last icon > under Label Option uncheck all except Percentage and under Label Position select Center.
Click on Total Revenues by Year 2018-2021 line chart (in the range A11:G28), new section will appear on left. Click on dropdown > Vertical (Value) axis > last icon > change Minimum bound to 2500000 > under Units, change the major units of the vertical axis to 500000 change the minor units to 250000.
Select Tick Marks and choose Inside tick marks for the minor units.
Video instruction: