House Type Analysis You will analyze each house type to determine if the company has a tendency to purchase a certain type of a house. p. Create a 2D-Pie chart that displays the total number of houses by house type and apply chart type Style 7. q. Move the chart to the left side of the screen directly under the table data. r. Change the chart title to House Type. S. Move the legend to the top-left corner. t. Explode the largest piece of the pie to a Point Explosion of 20% u. Add Data Callout data labels to the chart. File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share fx Define Name Insert Function |?| AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference Trig Functions Function Library Use in Formula Name Manager 20 Create from Selection Defined Names & Trace Precedents Vfx Show Formulas Fa Trace Dependents Error Checking Remove Arrows Evaluate Formula Formula Auditing -69 Watch Window Calculation Options Calculation D10 1 X fx H . 1 J 0 P. Q Q R S B Jan G Jun N Total Aug Feb 1 1 1 D Mar 1 1 E Apr 1 3 Jul 1 1 M Dec 1 1 F May 1 0 2 1 1 L Nov 1 2 K Oct 0 1 0 Sep 2 1 0 1 A 1 Data 2 Colonial 3 Ranch 4 Bungalow 5 Split-Level 6 Tudor 7 2 1 1 Oo oo 10 14 7 || 0 1 0 1 2 o o 1 1 O NA 0 2 0 0 1 1 7 0 0 1 1 1 1 0 2 1 0 2 1 9. 8 9 10 11