Tip Amounts
Bartender $	Assistant $	My Net Tip $
$3.15	$0.82	$2.03
$3.83	$1.00	$5.18
$9.02	$2.16	$11.17
$3.49	$0.89	$2.62
$4.62	$1.17	$6.21
$1.46	$0.42	$1.62
$1.17	$0.39	$2.45
$5.92	$1.45	$6.62
$10.12	$2.70	$17.18
$3.16	$0.82	$5.02
$5.59	$1.47	$6.94
$7.59	$1.90	$10.51
$1.10	$0.24	$0.66
$2.29	$0.63	$2.58
$6.76	$1.73	$11.50
$3.64	$0.99	$4.22
$1.25	$0.27	$0.48
$2.23	$0.55	$3.22
$6.06	$1.51	$7.43
$3.82	$0.96	$7.22

Create a Pie Chart on a New Sheet (use Excels features for a New Chart sheet) that compares the bartender tips, the assistant tips, and your net tips from each of the 20 customers. Name the worksheet, Tips Chart. Ensure that the data markers on the data points are showing on the Pie Chart. (4 marks) V) Change the Chart title, Tips Chart and add a Legend at the top of the chart. Show the data labels on the highest tip amount for each of the bartender, assistant, and you. (3 marks) W) Add a vertical and horizontal axis label. These should read Tips and Customers. (2 marks) X) Create a clustered column chart on a new sheet and repeat the steps U, V, X, and W. Use combo chart option to show my net tip average (10 marks) Y) Rename the excel sheets in the workbook as you wish (be creative) and apply different colors to them (4 marks)