I want to create a chart that counts occurrences from two different columns which might not have the same values.

Here is a sample data:

Example table

Be aware that the unique values might not be the same in each column (in this example, "Start Week" does not have "5")

The expected result is similar to the image below:


The straight line is for "Start Week" and the squiggly one is for "Finish Week".

This appears to be a simple task, but I've struggled a lot in my attempts.

1 Answer 1



If this result is good for you, see this sheet.

  • Thank you for the answer! This is the expected result but the solution seems a bit complicated 😅 I hoped that extra tables were not necessary...
    – Ícaro
    Commented Apr 2, 2022 at 23:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.