6. Emphasize the Rowed data point. a. Rotate the pie chart 240 degrees until the Ranch data point is at the right side. b. Explode the Ranch data point away from the pie by 30%. c. Apply the Circle bevel shape effect to the Ranch data point. . In the column chart, change the color of each data point to match the corresponding color in the pie chart. You do not need to change the color of the Modern data point. a. In the column chart, apply the Orange, Accent 2 fill color to the Condo data point. b. In the column chart, apply the Gold , Accent 3 fill color to the Ranch data point. c. In the column chart, apply the Green , Accent 4 fill color to the Mediterranean data point. 8. Add a callout to the column chart to emphasize the Rasco data point. a. Add a Line Callout 1 shape to the chart. b. Add the text : 32 4 of total c. Resize and position the callout so it is pointing to the Ranch column as shown in Figure EX 7.49. d. Change the shape style to Subtle Effect - Gold, Accent 3 9. Apply the Fill - Dark Red , Accent 1, Shadow WordArt Quick Style to the column chart title. 10. Apply the Dash Dot dashes line option to the column chart gridlines. Sales by House Type Sales by House Type 120 090.000 $18.600-000 32% of total 414.600 060 $1 4600 000 Bone $12090.000 #10804 000 1400.00 $2.030.090 "Condo Ranch #Mederoneon Mogen Cando FIGURE EX 7.49 11. Add a trendline to the 1 and 2 Bedroom Condo Sales chart on the Condo Sales worksheet. a. Switch to the Condo Sales worksheet. On the Chart Design tab, click the Add Chart Element button , point to Trendline and select More Trendline Options. c. In the Trendline Options select Moving Average and verify that the period is set to 2