1

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?

migrated from superuser.com Feb 2 at 12:01

This question came from our site for computer enthusiasts and power users.

0
  • 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 acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.