I have two financial accounts; each gets updated on unpredictable dates.
So (to oversimplify a bit for the sake of asking the question) - Sheet1 has Date/Balance, Sheet2 has Date/Balance.
I have a line-graph which plots the Balance of Account 1 against Date, and also plots the Balance of Account2 against Date, using the same Date baseline as the X Axis
However, it would be really useful to see the combined balance of the two accounts, at any given date.
I can’t provide that value in a Cell, because Sheet1 might not have an entry for that date, or Sheet2 might not have an entry for that date, so I don’t see a way to create a combined spreadsheet for the two accounts.
But the graphing functionality is successfully creating a graph of the two Balances, over the same timeline - so there must be a way to tell it to create a third line in the graph, which plots the sum of the two balances?
I accept that it won’t be a truly reliable figure, in that Sheet1 might go a month without an update, while Sheet2 gets five updates, so Sheet1 stays flat until it gets an update on its balance, which won’t reflect reality. I’m not wanting total reality, just a way to show what the value is of these two sheets for a given date.
Presumably this is possible, but my googling hasn’t found a way, yet - so I hand over to the Gurus on this board…