How to link two charts with different field names from front end

[#1]

Hi:

I have two charts shown below. I want Column A and Column C to be linked , So when I filter on the first chart , the second chart's result changes as well.  I want to avoid creating a key in the script that link these two fields because my data model is a little too complex. Is there a way just to link them from the front end using some chart expression?

Thanks

Chart 1

Column A	Column B
X
Y

Chart 2

Column C	Column D
Z
X

[Gysbert_Wassenaar]

You can try assigning Select in Field actions to the field triggers of those fields so that a selection in one field triggers a the Select in Field action that makes a selection in the other field. See for example this discussion: Copy Selections from one field to another