1. Excel steps to create the bar chart are as follows:

a. Open Excel and from Connect, select Data Files, Tables, and select Table 2–1.

b. In cell B76, enter the label Type. In cells B77:B79, enter the labels Apartment, House, and Row/Townhouse. In cell C76, enter the label Number of Listings. In cells C77:C79, enter 9, 38, and 21. Select the range C76:C79.

c. From the toolbar, Select INSERT. From the Charts subgroup, select Insert Column Chart, and click the first Chart sub-type: Clustered Column.

d. Click the Chart Title to edit; click the legend to remove it.

e. To edit the X-axis (horizontal axis) titles, right-click any label and click Select Data. In the Horizontal (Category) Axis Labels section, click Edit. In the Axis label range box, select the data range that contains the labels ‘Apartment, House, Row/Townhouse’. Click OK, OK. Note: the Excel chart type Bar will create a horizontal bar chart.