Having two tables with the following data (with 0 representing sad and 1 happy) I need to have one graph for the two tables. The IDs are unique for each table.
I tried implementing it as two different pivot tables or as one regular table with a relationship but didn't succeed. Using Excel.
Is it the right approach? How can I merge both tables into one pivot chart? Maybe with vlookup?
Table 1 - group A:
| ID | happy/ sad |
|---|---|
| 123 | 0 |
| 456 | 1 |
| 789 | 0 |
Table 2 - group B:
| ID | happy/ sad |
|---|---|
| 111 | 1 |
| 444 | 1 |
| 888 | 0 |
CodePudding user response：
Thanks @Isolated. I used four different countIf and made a new chart with the answers and then a graph
CodePudding user response：
A curious feature of the IFERROR() function is that, even in legacy Excel, it can be used to stack data, e.g.
such that the A8:B13 range could be used as the source data for your combined chart.
(being an array formula, the combined source will not grow with changes in the size of your tables but, in your context, where I imagine each table is a specific population, I would imagine that they are static once tabulated)