Problem of New Perspectives Excel 2019 | Module 4 - End of Module Project 2
Geneva wants a clustered column chart representing the total revenue for each insurance type by year. Create a 2-D clustered column chart based on the range A5:E9. Resize and reposition the chart so that the upper-left corner is located within cell H5 and the lower-right corner is located within cell O24. Enter Yearly Revenues by Insurance Type as the chart title, then bold the title, and change the font size to 16 point.
Apply a Green, Accent 6 border to the plot area of the chart and change the width of the border to 1.5 point. Apply a Glow Shape Effect to the chart area using 5 point Green, Accent Color 6.
Select A5 through E9 > Insert Tab > 2-D columns > Clustured column. Reposition it by dragging and stretching. Enter Yearly Revenues by Insurance Type as the chart title, then bold the title, and change the font size to 16 point (select the text and it will give options to blod it and adjust font size). Make sure font is same when u paste it.
Click on chart, double click it to select plot area (inside section) > Click Format tab > shape outline > Green, Accent 6. Again, Format tab > shape outline > Weight > more lines > width to 1.5.
Select chart area (outside section). Format tab > Shape effects > Glow > 5 point Green, Accent Color 6
Select A5 through E9 > Insert Tab > 2-D columns > Clustured column. Reposition it by dragging and stretching. Enter Yearly Revenues by Insurance Type as the chart title, then bold the title, and change the font size to 16 point (select the text and it will give options to blod it and adjust font size). Make sure font is same when u paste it.
Click on chart, double click it to select plot area (inside section) > Click Format tab > shape outline > Green, Accent 6. Again, Format tab > shape outline > Weight > more lines > width to 1.5.
Select chart area (outside section). Format tab > Shape effects > Glow > 5 point Green, Accent Color 6
Youtube video: https://youtu.be/_hss1eRW-B0?t=93