Hello good people of the Excel Forum.

Here is the type of situation...say you have 100 rows of data entries on a table in one tab. Other tabs then produce whole table summaries of various statistics along with bar graphs from this table. Question? Is it possible to filter objects in a column of the data table (ie. show only John, or Q4, or Marketing) and have the summary and chart tabs only reflect the stats for the filtered object (ie. show only Q4 summaries and charts)? Right now I can filter any object I like in the data table but the summary and charts tabs still only show stats for the entire table. So, I would like the calculations performed only on the object or objects I filtered (so I can see summaries and charts of subsets of the data).

If you can point me in the right direction with some key terminology phrases, I can better address the person maintaining the sheet.

Thank you.