I can’t figure out how to compare two data sets with date intervals form each year.

Only the start and end date are the same days, the rest is spread over the period. And there can be more points in one data set than the other.

They should be compared in a graph in Google Sheets.

I have made this test sheet to show my data sets.

How can I do this without changing the data sets?

  • Did you ever figure out how to do this well?
    – Matt Winer
    Feb 25 '21 at 1:45
  • if you can't change positions of your dataset, then the best way would be using 2 mirrored charts and slightly overlay them:

  • demo spreadsheet

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy