Visual Workshop

Open IL$\_$EX$\_4-5.$xlsx from the location where you store your Data Files, then save it as IL$\_$EX$\_4\_$Insurance. Create, modify, and position the two charts, as shown in FIGURE $4-29.($Hint: Use the CTRL key as needed to select nonadjacent ranges.$)$ You will need to make formatting, layout, and design changes once you create the charts. $($Hints: The WordArt used in the pie chart title is Fill: Orange, Accent color $4$: Soft Bevel. The WordArt used in the column chart title is Fill: Turquoise, Accent color $1$: Shadow. The Life data point in the pie chart is exploded $30$ degrees.$)$ Enter your name in the center section of the footer, then save and preview the worksheet. Submit your work to your instructor as directed, then close the workbook and close Excel.

FIGURE $4-29$