How to Apply Apply Multiple Filters to Generate Dynamic Line Graphs

Occasional Visitor



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.



Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies