How to Apply Apply Multiple Filters to Generate Dynamic Line Graphs

Copper Contributor

Hi,

 

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.

 

 

Thanks for the assistance.

 

 

0 Replies