Project:

To design a chart and graph to provide a visual display of the Capture Rates for the week for the Hotel. Total points = 185

1. make a chart displaying the data included in the chart below. (20 points)
2. make a 'Total' in cell B9; use the 'thousand separator' function. (10 points)
3. make a 'Capture Rate %' using one decimal point for each of the empty cells in column 'D.' (25 points)
4. DO NOT use the '%' sign; Format each cell for one decimal without the '%' sign. (20 points)
5. Cells B9, C9, and D2:D9 MUST all contain formulas. (20 points)

total number of rooms sold no. of diners capture rate%

monday 181 73

tues 173 91

wed 196 101

thurs 201 113

friday 228 143

saturday 231 139

sunday 165 61

total

make a Graphic using this data. (See example)

1. Use the data to make a '3-bar chart.' (20 points)
2. Place the graphic directly beneath the chart (make sure they both fit it on just one page - check your 'print preview' to make sure they print on ONE page. (20 points)
3. Make sure to include the headers. (5 points)
4. Add a Title/Header as indicated in the example. (10 points)
5. Change the color of the background (make it light so as to read the chart clearly). (10 points)
6. Add a 'Data Label' to the 'percentage bar.' (as shown) (15 points)
7. Add a border around the graphic (black; 2-point width) (5 points)
8. Change the 'Sheet1' tab to "Assignment #21" (5 points)