In Google Sheets I have two timeline charts with source data Sheet1!A1:B100 and Sheet2!A1:B100. Dates in Sheet1!A and Sheet2!A mostly do not overlap - Sheet1!A are more or less random (datapoints are collected once every 1-2 weeks) and dates in Sheet2!A are 1st day of every month (datapoints are autogenerated once a month).
If I just add data range Sheet2!A1:B100 to timeline chart plotting data range Sheet1!A1:B100, I get error "Each values column may be followed by one or more annotation columns. column number 2 is of type date".
Is there a way to merge two timeline charts with different date-sets?
edit: here is a sheet with the problem: https://docs.google.com/spreadsheets/d/1TGoHPodslxw01PVf8Yp4SI15saedY8iID3FegJg6lmg/edit#gid=1772915307
I would like to merge those two graphs. I'd like to have those two lines on the same graph.