Question: i want answer for first 3 parts U) Create a Clustered Column Chart on a new Sheet (use Excel's features for a New Chart sheet)

i want answer for first 3 parts

i want answer for first 3 parts U) Create a Clustered ColumnChart on a new Sheet (use Excel's features for a New Chart

U) Create a Clustered Column Chart on a new Sheet (use Excel's features for a New Chart sheet) that compares the bartender tips, the assistant tips to your net tip for all 20 customers. Name the worksheet, \"Tips Comparison\". Use combo chart option to show my net tip average (10 marks) (14 marks) V) Change the Chart title, "Tips Chart\" and add a Legend at the top of the chart. Show the data labels as you see fit for each of tl'lhsbartender, assistant, and you (3 marks) W) Add a vertical or horizontal axis label. It should read \"Tips\". (2 marks) X) Create a 3Dclustered column chart on a new sheet only using the totals of columns G, H and l and add Chart title "'3'ips Chart" (10 marks). Tip Amounts Bartender $ Assistant $ My Net Tip $ 0.74 1.25 S 1.99 0.93 S 1.50 S 2.43 1.13 $ 3.27 S 4.40 0.74 1.30 2.04 0.93 1.71 S 2.64 0.58 S 0.59 1.17 0.74 S 0.58 1.33 0.93 S 2.14 3.07 2.78 3.88 6.66 0.74 1.19 S 1.93 1.42 2.12 S 3.55 1.42 2.79 S 4.21 0.37 $ 0.37 0.74 0.90 S 1.64 1.49 2.52 4.01 1.13 1.42 2.55 0.42 0.42 0.39 0.81 1.20 1.07 2.21 S 3.29 0.74 1.41 2.15 $18.65 $32.38 $51.03 of the drink order

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!