I have two tabs
Sheet2 with two columns each:
Temperature. I want a single chart of temperatures against date.
The problem is that the date columns are not necessarily identical (some dates are missing from some sheets). So, what I want to do is (full outer) join of the two tables on
Date and then plot the two
Temperature columns against the combined
The other problem is that new records are updated daily to the sheets and I want the chart to be updated automatically as it happens.
This can be relatively easily done in
Python; however, it would be nice to do this in a more "visually interactive" environment.
Thus, my questions are: how to combine the two
Date charts into one (taking care of the missing data) automatically so that no action is required when the sheets are updated?