Use a Data > PivotTable to create a chart giving you your summaries.