Bedrooms. Name the PivotTable Bedroom Rata. Select the
Apartment Name field from the COMPLEX table for Rows,
the # Bed field for Columns, and the # Bed field as Values.
This will display the number of apartments with the specified
number of bedrooms per apartment complex. Display the
values as a percentage of row totals. Create a Clustered
Column PivotChart. Cut the chart and paste it in cell A13.
Select the 3-bedroom data series and apply the Black, Text 1,
Lighter 50% solid fill color. Apply Black, Text 1 font color to
the vertical axis and category axis. Change the chart height to
3 inches and the width to 5 inches, if necessary. Hide the
field buttons in the PivotChart. Create a footer on all
worksheets with your name in the left, the sheet name code in
the center, and the file name code in the right. 21 Save and
close Exp19_Excel_Ch05_Cap_Apartments.xlsx. Exit Excel.
Submit the file as directed. Total Points 100