Question: 13. Create a clustered oolumn chart for population gross-Bl by region. More the chart to its own chart sheet named Egalm! Trends 2. b. d.

 13. Create a clustered oolumn chart for population gross-"Bl by region.

13. Create a clustered oolumn chart for population gross-"Bl by region. More the chart to its own chart sheet named Egalm! Trends 2. b. d. E. Go to the Census Data by State worksheet and select cells A513. On the Iman'tab, in the cm group, click the Insert Column or Bar Chart button and select Clustered Column {the rst chart under the 2D Cam section}. If necessary, change die x axis labels to match the column headings. On the cam Tana: Dal-{gs tab, in the Dam group, click the Select Data button. In the Hazamd r'CaIrgagj Axis Labels box, click the Edit button, and then click and drag to select cells 33:13. Click OK Click OK to accept the changes to le chart On the Chart Tani: Design tab, in the 1.0th group, click the Move Chart button Click the New Sheet radio button. Type Regional Trends in the box and click OK 14. Edit and format the chart title. a. b. E. Click the chart title and type: Population Trends by Region On the Chant Trials Format tab, in the Warden rye group, click the More button to expand the gallery, and select one of le WordArt options. Click anywhere outside the title 15. Add trendlines to the chart to forecast exponential growth for the next 40 years. a. b. c. d. Click the Chart Elements button that appears near the upper night comer of the chart Point to TrendJine, click the arrow that appears, and click More Options. In the Add Deadline dialog, click OK. (Ahmrr should be selected by default} In le Fol-mar Testies task pane, click the Exponential radio button. In le Fem-arr section, type 4 in the Famam'box

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!