The dataset will be provided to you in an Excel file

showcase three graphs from the data in the tab labeled "Chart Data". Each graph will include a descriptive title, labeled axis and legend.

Develop the following original charts from the data tables. Copy each chart into the blank tab named "Charts" in the Excel File you are given. Your charts will use 3 - 5 values and not all of the values in the file you are given. a. 3 D Pie Chart - Must show percentages in each slice and must contain a descriptive heading. Include a legend. There is an example of a pie chart below. b. Column Chart - You may use the same data from the Pie chart. The only difference will be that the data will be displayed in a column chart. Format Chart to add a Heading and the Horizontal and Vertical labels. c. Clustered Column Chart - must contain a Heading and the Horizontal and Vertical labels. There is an example of a clustered column chart with different data shown below

showcase a Pivot Table from the data in the tab labeled "Pivot Table Data". Ensure it has a Column of "Account" and a Row of "Payee". The values from the column labeled "Amount" in the table will be displayed as values in the Pivot Table. You can insert the Pivot Table into the same tab as the data or in a new tab. An example of a Pivot Table is shown below

G1:G1048576 fx 2 = B C D E F G Payee Franchise Tax Board DE Dept of Corp Yay of California DE State Tax Soladdy SSC A 1 2 3 Date 4 04/17/16 5 09/12/16 6 04/12/16 7 4/20/16 8 10/9/16 9 10/9/16 10 04/10/16 11 01/17/16 12 01/27/16 13 02/27/16 14 03/27/16 15 4/20/16 16 04/27/16 17 05/27/16 18 10/9/16 19 07/12/16 20 10/15/15 21 4/20/16 22 04/17/16 23 04/17/16 24 04/17/16 25 10/9/16 26 10/9/16 27 01/17/16 28 04/17/16 29 4/20/16 30 10/9/16 31 07/12/16 32 01/15/16 33 04/15/16 34 04/15/16 35 07/15/16 36 08/15/16 37 09/15/16 38 10/15/16 39 10/9/16 40 41 101 Domains Franchise Tax Board Sensulte Sevylter Sevylter DE State Tax Sensulte Sensulter Sobeddy Eisenglese Insurance Tase PosBER DE State Tax Franchise Tax Board Feray land1 GoDaddy SSC Franchise Tax Board Franchise Tax Board DE State Tax SSC Esunglese Insurance Amazon Web Services Amazon Web Services Arazon Web Services Amazon Web Services Arazon Web Services Amazon Web Services Amazon Web Services GoDaddy Purpose Account CA Tax 2015 ABC Corp Corporate Filing ABC Corp License Fee ABC Corp DE Tax 2015 ABC Corp Domain fee ABC Corp Corporate Filing DEF Corp Domain fee DEF Corp CA Tax 2015 DEF Corp Consulting DEF Corp Consulting DEF Corp Consulting DEF Corp DE Tax 2015 DEF Corp Consulting DEF Corp Consulting DEF Corp Domain fee DEF Corp Corporate Insurance DEF Corp Tax Prep WS DE Tax 2015 WAS CA Tax 2015 WS VoIP Phone Service XVIIS Web Hosting WAS Domain fee WAS Corporate Filing WAS CA Tax 2015 W US CA Tax 2015 WAS DE Tax 2015 WIS Corporate Filing W2945 Corporate Insurance XVIIS Software WILS Software Xys Software WILS Software XUS Software Xys Software XUS Software Xys Domain fee WILS Payment Check Check Check Check Credit Card Credit Card Check Check Check Check Check Check Check Check Credit Card Check Check Check Check Credit Card Credit Card Credit Card Credit Card Check Check Check Credit Card Check Credit Card Credit Card Credit Card Credit Card Credit Card Credit Card Credit Card Credit Card Amount 800.00 200.00 1,000.00 300.00 28.26 192.00 218.90 162.00 700.00 1,500.00 1,200.00 300.00 2.500.00 1.800.00 54.28 1,349.00 1.800.00 300.00 800.00 606.36 178.32 54.28 192.00 162.00 800.00 300.00 344.00 1,146.00 55.42 57.17 57.17 55.47 55.47 55.47 55.47 32.34 192 Sum of Amount I Column Labels Row Labels | ABC Corp DEF Corp XYZ LLC Grand Total 101 Domains 218.9 218.9 land1 178.32 178.32 Amazon Web Services 391.64 391.64 Consulto 7700 7700 CSC 536 728 DE Dept of Corp 200 200 DE State Tax 300 300 600 1200 Exampleco Insurance 1349 1146 2495 Fonality 606.36 606.36 Franchise Tax Board 800 162 1762 2724 GoDaddy 28.26 54.28 86.62 169.16 Taxco Prepco 1800 1800 Unv of California 1000 1000 Grand Total 2328.26 9976.18 7106.94 19411.38 G1:G1048576 fx 2 = B C D E F G Payee Franchise Tax Board DE Dept of Corp Yay of California DE State Tax Soladdy SSC A 1 2 3 Date 4 04/17/16 5 09/12/16 6 04/12/16 7 4/20/16 8 10/9/16 9 10/9/16 10 04/10/16 11 01/17/16 12 01/27/16 13 02/27/16 14 03/27/16 15 4/20/16 16 04/27/16 17 05/27/16 18 10/9/16 19 07/12/16 20 10/15/15 21 4/20/16 22 04/17/16 23 04/17/16 24 04/17/16 25 10/9/16 26 10/9/16 27 01/17/16 28 04/17/16 29 4/20/16 30 10/9/16 31 07/12/16 32 01/15/16 33 04/15/16 34 04/15/16 35 07/15/16 36 08/15/16 37 09/15/16 38 10/15/16 39 10/9/16 40 41 101 Domains Franchise Tax Board Sensulte Sevylter Sevylter DE State Tax Sensulte Sensulter Sobeddy Eisenglese Insurance Tase PosBER DE State Tax Franchise Tax Board Feray land1 GoDaddy SSC Franchise Tax Board Franchise Tax Board DE State Tax SSC Esunglese Insurance Amazon Web Services Amazon Web Services Arazon Web Services Amazon Web Services Arazon Web Services Amazon Web Services Amazon Web Services GoDaddy Purpose Account CA Tax 2015 ABC Corp Corporate Filing ABC Corp License Fee ABC Corp DE Tax 2015 ABC Corp Domain fee ABC Corp Corporate Filing DEF Corp Domain fee DEF Corp CA Tax 2015 DEF Corp Consulting DEF Corp Consulting DEF Corp Consulting DEF Corp DE Tax 2015 DEF Corp Consulting DEF Corp Consulting DEF Corp Domain fee DEF Corp Corporate Insurance DEF Corp Tax Prep WS DE Tax 2015 WAS CA Tax 2015 WS VoIP Phone Service XVIIS Web Hosting WAS Domain fee WAS Corporate Filing WAS CA Tax 2015 W US CA Tax 2015 WAS DE Tax 2015 WIS Corporate Filing W2945 Corporate Insurance XVIIS Software WILS Software Xys Software WILS Software XUS Software Xys Software XUS Software Xys Domain fee WILS Payment Check Check Check Check Credit Card Credit Card Check Check Check Check Check Check Check Check Credit Card Check Check Check Check Credit Card Credit Card Credit Card Credit Card Check Check Check Credit Card Check Credit Card Credit Card Credit Card Credit Card Credit Card Credit Card Credit Card Credit Card Amount 800.00 200.00 1,000.00 300.00 28.26 192.00 218.90 162.00 700.00 1,500.00 1,200.00 300.00 2.500.00 1.800.00 54.28 1,349.00 1.800.00 300.00 800.00 606.36 178.32 54.28 192.00 162.00 800.00 300.00 344.00 1,146.00 55.42 57.17 57.17 55.47 55.47 55.47 55.47 32.34 192 Sum of Amount I Column Labels Row Labels | ABC Corp DEF Corp XYZ LLC Grand Total 101 Domains 218.9 218.9 land1 178.32 178.32 Amazon Web Services 391.64 391.64 Consulto 7700 7700 CSC 536 728 DE Dept of Corp 200 200 DE State Tax 300 300 600 1200 Exampleco Insurance 1349 1146 2495 Fonality 606.36 606.36 Franchise Tax Board 800 162 1762 2724 GoDaddy 28.26 54.28 86.62 169.16 Taxco Prepco 1800 1800 Unv of California 1000 1000 Grand Total 2328.26 9976.18 7106.94 19411.38