Home /
Expert Answers /
Computer Science /
help-struggling-with-excel-module-1-sam-project-b-11-ashley-wants-to-visualize-the-total-year-to-da-pa209
(Solved): help Struggling with Excel module 1 SAM project B 11. Ashley wants to visualize the total year to da ...
help
Struggling with Excel module 1 SAM project B 11. Ashley wants to visualize the total year to date sales separated into states. Insert a chart to provide this visualization as follows: a. Create a 2-D Pie Chart based on the nonadjacent ranges A8:A12 and H8:H12. b. Enter Total Year to Date Sales by State as the chart titie. c. Reposition and resize the chart so its upper-left corner is in cell K3 and its bottomright corner is in cell M17 d. Apply Style to the chart.
Expert Answer
Here are the steps to complete this task: Select cells A8:A12 and H8:H12 by holding down the Ctrl key and clicking on each range. Then, go to the Insert tab on the ribbon and click on the Pie Chart icon in the Charts group. Choose the 2-D Pie Chart option.Select cell A8 and press and hold the Ctrl key.While holding the Ctrl key, select cells to .Release the Ctrl key.Press and hold the Ctrl key again.