- Joined
- Oct 27, 2008
When you open the attached excel workbook you will see a worksheet with data and two charts next to it.
Chart 1 is basically all the data in Table 1 with no way to filter the data. This is not very helpful when trying to compare certain values to look for trends.
In Chart 2 I've referenced cells in the Table 2 that should be populated by the IF AND THEN etc... type statements as they relate to the TRUE/FALSE values of the check boxes at the bottom of the chart and sourced from Table 1.
As you can see the "Samples" come in solid or liquid and further be divided by color... I would like to write IF AND statements in the second table so that when the box is checked or unchecked the dynamic table will only display the correlating data.
To do this where there is only 1 variable per column is easy but when there are more than one possible values the syntax becomes a nightmare....
PM me if you have a solution so I can give you my email address.
Chart 1 is basically all the data in Table 1 with no way to filter the data. This is not very helpful when trying to compare certain values to look for trends.
In Chart 2 I've referenced cells in the Table 2 that should be populated by the IF AND THEN etc... type statements as they relate to the TRUE/FALSE values of the check boxes at the bottom of the chart and sourced from Table 1.
As you can see the "Samples" come in solid or liquid and further be divided by color... I would like to write IF AND statements in the second table so that when the box is checked or unchecked the dynamic table will only display the correlating data.
To do this where there is only 1 variable per column is easy but when there are more than one possible values the syntax becomes a nightmare....
PM me if you have a solution so I can give you my email address.
Attachments
Last edited by a moderator: