I am new to Pivot Tables and large data analysis. I am trying to figure out how to build a dynamic line graph that auto-generates up to 4 separate series based on user selected data from drop down menus which would auto filter the data set.
The data is related to condition data that is collected on a bi-annual basis at several data points for several different conditions. My issue is that each each column in the data set actually has several associated qualities and I want to filter the data based on one or multiple of those qualities.
I have attached a small sample of the data. The Location will always be the chart range (X-Axis), and the Criteria will always make up the Series Data. I just want the users to be able to select which criteria they want to see.