5. Create a column chart to represent the population data for Houston and then add a second series to represent the overall population of the United States. a. *' Select cells A3:F3. Press and click and drag to select cells A7:F7. b. On the insert tab. in the Charts group. click the Column or Bar Chart button, and choose Clustered Column (the rst chart type under 27D Column). c. *' Click and drag the chart to reposition it immediately below the data. d. On the Chart Design tab, in the Data group. click the Select Data button. 1:. Alternate On the Chart Toots Design tab. in the Data group, click the Select Data button. e. V In the Legend Entries (Series) box. click the Add button. f. Click cell A15 to add the cell reference to the Series name box. 9. Click in the Series vaiues box and delete the default entry. Click and drag to select cells BI 5:F15. h. Click OK. i. V' Click OK again to close the Seiect Data Source dialog. 6. Change the chart type to a combination chart with a secondary axis for the national population data. a. J On the Chart Toots Design tab, in the Type group, click the Change Chart Type button. {I Alternate On the Chart Design tab, in the Type group, click the Change Chart Type button. b. In the list of chart types at the left side of the AH Charts tab, click Combo. c. \"' Excel automatically suggests a line chart for the Totai US popuiation series, but the scale difference between the two series makes the Houston data unreadable. Click the Secondary Axis check box next to Totai U5 popuiation series. d. Click OK. I! 19 I! 19 19 1') 13 1'3 I! 1'3 1'3 IQ 1'3 Population of the 10 Largest U.S. Cities City Name Year 1970 1980 1990 2000 2010 New York, NY 7,895.563 7,811, 801 7.322,564 8,008,278 8,391,881 Los Angeles, CA 2, 811,801 2,968,528 3,485398 3,694, 820 3,831,868 Chicago, IL 3.369.357 3,005,072 2,783,726 2,896,016 2,851,268 Houston, TX 1,233.535 1,595,138 1,330,553 1,953,631 2,257,926 Phoenix, AZ 584.303 789.704 983,403 1,321, 045 1,601,587 Philadelphia, PA 1,949.996 1,688,210 1,585.577 1,517,550 1,547,297 San Antonio, TX 654, 153 785,940 935.933 1,444, 646 1,373,668 San Diego, CA 697,471 875 538 1,110,549 1,223,400 1,306,301 Dallas, TX 844,401 904.599 782,248 1,185,580 1,299.543 San Jose, CA 459.913 629,400 782,248 894.943 964.695 Total US population 203, 211,926 226,545,805 248,709,873 281,421,906 306,745.538 Chart Title 9,900,000 350,000,000 8,000,000 300/000/000 7/000,000 5/000,000 250,000,000 5/000,000 200,000,030 4/000,000 150,000,000 3/000,000 100/000,000 2/000,900 1,000,000 "P,000,000 1970 1980 1940 2000 2010 New York, NY Los Angeles, CA Chicago, IL - Houston, TX Total US population