help determine what product lines should be expanded.

Switch to the Product Material PT worksheet. Insert a PivotChart using the Clustered Column chart type. Format the PivotChart as described below:

a$.$ Resize and reposition the Pivotchart so that the upper$-$left corner is located within cell F$3$ and the lower$-$right corner is located within cell $019.$

b$.$ Add the chart title Sales by Frames to the PivotChart using the Above Chart option.

Use the Type axis field button to filter the Pivotchart so that only the sales data for Prescription and Reading glasses of each type of material appears in the chart.