Thread: Auto update legend?

I am working on a database which contains 100 of the same test. Tests are subdivided by location where they were done.

I have set up a sheet to plot all 100 and then used filters to allow me to just display test from a specific location but the legend still displays all 100 items. I can go in and manually delete unrelated legend items but it becomes very tedious.

Is there any way to have the legend update based filter criteria?

Nevermind... it actually works now. Thats strange.

Thanks anyways!