Combining data from two similar tables into one PivotChart

Hi, hoping someone can help.

I have two tables on seperate sheets, tracking candidate journeys through a recruitment process.
Both tables have a column heading "Status", holding the Candidate's current status.
Some of the options are the same in each table (e.g. Testing) some are different (e.g. one will have "ProcessA_Interview", the other "ProcessB_Interview).

I'd like to display both columns into one PivotChart so I can display the number of Candidates at each stage.
So status' that show up in each table combine the figures from each table.

I can't find a way of creating a relationship so any help would be great