Filterering Chart Data

Question: How does one go about using a filter on a dataset, and have that filtered data effect a chart that is pointing to the dataset?

Example:

I have a worksheet that has my data in a format similar to

Ticket# Time a Time b Location

1 12:05 12:07 London
2 12:35 1:02 LA
3 1:00 1:05 LA
4 2:00 3:00 London

On a second worksheet, I have a table that averages time b and time a so that the average values can be displayed in a chart that graphs out the average Time A and average Time B based on ticket#.


I would like to filter based on location, and then have the chart on the second worksheet update and display only the average time of the filtered data... any suggestions? Seems there would be a simple way to acomplish this rather than build a whole new table or pivot table that averages only the filtered criteria...

Subtotal function worked like a charm... You rock!