I have a bit of a head scratcher here, specifically with how I am going to structure this.
What I need to accomplish is to have the 5 dropdowns input values to the chart in a "combined" fashion, that is to say, #Selection1 will have 5 values, #Selection2 another 5 and so on, without physically having to run over 3000 if-statements.
#Selection1 will have 5 options, and each of #Selection2's 5 options will be applicable to each of #Selection1's 5 options and so on, but will have to dispay different values on the chart. For example, let's assume #Selection1 is Age with 5 age groups, and #Selection2 is 5 different Coffees. If I am aged between 25 - 35 and prefer cuppachino's, the chart will display different data than someone who is also aged beween 25 - 35 but prefers plain black coffee, and also different data for someone who is 45 - 55 but prefers cuppachinos.