Question: Create a 3-D pie chart (in this worksheet) showing the Wages per Job Title. Use data from the cells in the Java Juice Staffing Guide.

  1. Create a 3-D pie chart (in this worksheet) showing the Wages per Job Title. Use data from the cells in the Java Juice Staffing Guide. The Pie Chart should have 4 wedges and show a legend for full credit.

  1. The wedge with the highest wages, should be pulled away from the center of the pie. Complete the chart with title. Move the chart to a new Sheet. Name the sheet Wages.

  1. Create a 3-D bar chart from the ChartData worksheet, showing the No of Championship by NBA Player. Use date from the cells in the VLOOKUP and Charts Table. The Bar Chart should have 6 horizontal bars for full credit. Do not show a legend in the chart - the names of the players should appear in the vertical axis.

  1. Complete the chart with title and any formatting you choose. Move the chart to a new worksheet. Name the sheet Champ. Format it in any way you prefer.  Create a 3-D pie chart (in this worksheet) showing the Wages

Java Juice Staffing Guide - Hours Worked by Job Title Breakfast Lunch Dinner Daily Total Customers per hour 79 60 44 960 Pay Wages Percent Hours per period 5 Hours 6 Hours 5 Hours 16 Hours Rate In $ of Wages Cashier Barista Chef Cleaning staff Total $0.00 Bar Chart Data VLOOKUP and CHARTS TABLE NBA Player Seasons No. of Team championship Bill Russell 13 11 Celtics Kobe Bryant 20 5 Lakers Lebron James 18 4 Heat, Cavs, Lakers Michael Jordan 15 6 Bulls Shaquille 'O Neal 19 4 Heat, Lakers Stephen Curry 12 3 Warriors Java Juice Staffing Guide - Hours Worked by Job Title Breakfast Lunch Dinner Daily Total Customers per hour 79 60 44 960 Pay Wages Percent Hours per period 5 Hours 6 Hours 5 Hours 16 Hours Rate In $ of Wages Cashier Barista Chef Cleaning staff Total $0.00 Bar Chart Data VLOOKUP and CHARTS TABLE NBA Player Seasons No. of Team championship Bill Russell 13 11 Celtics Kobe Bryant 20 5 Lakers Lebron James 18 4 Heat, Cavs, Lakers Michael Jordan 15 6 Bulls Shaquille 'O Neal 19 4 Heat, Lakers Stephen Curry 12 3 Warriors

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!