Chapman Realty Company is seeking your help in analyzing the performance of its realtors over the last four months. During this time period the companys 12 realtors sold 99 properties (residential, commercial, and land) across six counties for a total of $30,637,161.

1. Summarize each realtors cumulative sales during the four-month period:

a. Using PivotTable, calculate the cumulative sales for each realtor during the four-month period.

b. Using PivotChart, create a bar chart that shows each realtors cumulative sales during the four-month period.

If you could just provide the detailed steps on how to answer this in excel that would be fine too.

B D E F 1 Month 2 October 3 January 4 November 5 November 6 October 7 November 8 January 9 January 10 January 11 October 12 November 13 October 14 November 15 January 16 November 17 December 18 January 19 October 20 January 21 October 22 December 23 November 24 December 25 November 26 December 27 November 28 December 29 January 30 December 31 January 32 December 33 October 34 November 35 October 36 January 37 October 38 December Selling Price Type $ 157,500 Commercial $ 88,800 Commercial $ 67,875 Commercial $ 53,938 Commercial $ 2,989,500 Commercial $ 2,027,375 Commercial $ 505,000 Commercial $ 242,500 Land $ 236,300 Commercial $ 127,250 Residential $ 108,125 Commercial $ 100,000 Land $ 98,750 Residential 64,400 Residential $ 62,719 Commercial $ 51,359 Commercial 44,258 Land $ 3,014,750 Commercial $ 717,000 Commercial 585,000 Commercial $ 288,422 Commercial $ 272,625 Land 204,469 Land $ 83,625 Residential $ 49,831 Commercial $ 47,500 Residential $ 536,844 Commercial $ 81,117 Commercial $ 50,158 Commercial $ 45,680 Land $ 41,875 Commercial $ 403,500 Commercial $ 368,938 Commercial $ 365,060 Land $ 287,000 Commercial $ 275,000 Residential $ 218,000 Commercial Realtor David Pullen David Pullen David Pullen David Pullen David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis David Willis Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Hal Keefer Jon Dolan Jon Dolan Jon Dolan Jon Dolan Jon Dolan Arturo James Arturo James Arturo James Arturo James Arturo James Arturo James Realtorld County 101 McDowell 101 Rutherford 101 Buncombe 101 Rutherford 102 Buncombe 102 Henderson 102 McDowell 102 McDowell 102 Polk 102 Polk 102 Buncombe 102 Polk 102 McDowell 102 Henderson 102 Buncombe 102 Polk 102 Henderson 103 Rutherford 103 Cleveland 103 Rutherford 103 Cleveland 103 Rutherford 103 Cleveland 103 Polk 103 McDowell 103 Cleveland 104 McDowell 104 Buncombe 104 Buncombe 104 Buncombe 104 Buncombe 105 Buncombe 105 McDowell 105 Rutherford 105 Buncombe 105 Henderson 105 Buncombe B D E TI $ $ $ $ $ $ $ $ $ $ $ 39 October 40 November 41 January 42 December 43 January 44 January 45 December 46 January 47 October 48 January 49 December 50 January 51 November 52 January 53 January 54 October 55 November 56 November 57 November 58 December 59 October 60 November 61 November 62 January 63 December 64 January 65 January 66 October 67 November 68 November 69 November 70 November 71 January 72 January 73 December 74 January 75 November 76 October is an uns us us us us us us us us us usu 214,500 Residential 98,156 Commercial 66,000 Residential 57,031 Commercial 44,916 Residential 22,000 Land 950,000 Commercial 164,211 Commercial 151,500 Residential 102, 105 Residential 60,316 Commercial 48,516 Residential 43,750 Residential 445,000 Commercial 245,000 Commercial 70,000 Land 69,375 Residential 55,000 Commercial 50,906 Land 47,344 Land 354,600 Land 176,250 Commercial 118,650 Residential 60,559 Residential 59,663 Residential 50,279 Land 47,270 Commercial 2,671,500 Commercial 697,875 Commercial 202,530 Land 80,633 Commercial 79,325 Land 67,500 Residential 54,539 Land 45,453 Residential 1,150,000 Residential 1,033,688 Land 221,750 Commercial Arturo James Arturo James Arturo James Arturo James Arturo James Arturo James Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Marcus Jackson Megan Cooper Megan Cooper Megan Cooper Megan Cooper Megan Cooper Megan Cooper Megan Cooper Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Melanie Aaron Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Eun Jung Bae Mitch Davis Mitch Davis Mitch Davis 105 McDowell 105 Buncombe 105 Buncombe 105 Buncombe 105 Henderson 105 Polk 106 Henderson 106 Buncombe 106 Cleveland 106 Rutherford 106 Polk 106 Buncombe 106 Polk 107 Buncombe 107 Buncombe 107 Rutherford 107 Polk 107 Henderson 107 Henderson 107 Buncombe 108 Rutherford 108 Cleveland 108 Polk 108 Buncombe 108 Buncombe 108 Rutherford 108 Buncombe 109 Henderson 109 Buncombe 109 Henderson 109 Cleveland 109 Cleveland 109 Polk 109 McDowell 109 Buncombe 110 Rutherford 110 Cleveland 110 Polk $ $ in us as an as an in us as an as an 76 October 77 October 78 December 79 October 80 January 81 October 82 January 83 November 84 November 85 November 86 January 87 November 88 November 89 December 90 October 91 October 92 October 93 January 94 January 95 January 96 November 97 November 98 November 99 January 100 December $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 221,750 Commercial 197,300 Residential 122,234 Residential 95,750 Residential 42,840 Commercial 312,500 Residential 163,500 Commercial 156,313 Commercial 130,875 Commercial 121,265 Residential 95,000 Land 85,438 Commercial 74,063 Commercial 69,078 Commercial 1,355,750 Commercial 970,500 Commercial 505,250 Commercial 486,800 Commercial 138,150 Land 129,000 Residential 61,813 Residential 54,688 Commercial 46,969 Residential 41,420 Commercial 40,938 Land Mitch Davis Mitch Davis Mitch Davis Mitch Davis Mitch Davis Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Nicole Ashby Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs Pete Jacobs 110 Polk 110 Henderson 110 Buncombe 110 Polk 110 Cleveland 111 McDowell 111 McDowell 111 Henderson 111 Buncombe 111 McDowell 111 Buncombe 111 Henderson 111 Buncombe 111 Polk 112 Cleveland 112 Buncombe 112 Cleveland 112 Polk 112 Cleveland 112 Buncombe 112 Buncombe 112 Polk 112 Rutherford 112 Polk 112 Henderson