20. lael also wants to summarize membership data for all organizations using a pivotchart to help determine which groups are showing the most interest from students. switch to the activities pivottable worksheet. based on the pivottable on the activities pivottable worksheet, insert a pivotchart using the clustered column chart type and format it as follows: a. resize and reposition the pivotchart so that the upper-left corner is located within cell f3 and the lower-right corner is located within cell o19. b. add the chart title membership by type to the pivotchart using the above chart option. c. filter the pivotchart so that only the membership data for groups with educational, field, and fraternal activities in each type of group displays in the chart. (this filter may be automatically applied when you create the table.)