I want to make a chart with a drop down at the top for "category" and when you select a catergory it only shows those locations and points on the graph.
I have the following fields:
I want the category to include a drop down that when you select the category the graph changes accordingly. Also, there should be a catergory for ALL.
I have done this many years ago using the OFFSET function however I cannot fully remember how to do it.