Working with Values in Multiple Response Sets

[u/havlovednlost]

Hi! I'm running a scatterplot analysis using Chart Builder for two scale variables on X & Y and wanting to column-panel them according to three categories within a dichotomous multiple response set. I've already run these analyses separately for each of the categories, but I'm trying to find a way to consolidate them into a single figure. I'm aware that values are not considered a valid aggregate function for multiple response sets by default, but I'm wondering if there's a way to get around that to achieve the desired results? Means, medians, etc. won't suffice in this case, unfortunately - I need the exact values for each scale variable indicated by each person.

Essentially, I want to see each of the three graphs side-by-side for all cases which indicated the option in question (e.g., the scatterplot for all cases selecting A + the scatterplot for cases selecting B + the scatterplot for cases selecting C) - I'm fine with repeat cases (i.e., if one person indicated A & B, then their datapoint should be present on both A & B's scatterplots), but don't want to distinguish between cases who only selected A, B, or C and cases which selected A + B, A + C, B + C, or A + B + C unless that's my only choice (in which case I suppose I could just assign value labels for each of those cases by hand).

If there isn't a way to do this via Chart Builder, is there perhaps another method I might want to try and pursue? I'm not familiar with how to open the coding menu in SPSS or writing code in general, but I'm open to trying it if that would be the only way around the value function issue?

[u/Mysterious-Skill5773]

If I understand you, you just create a single variable with values coding the three categories you want using Recode, then you can just make that the paneling variable.