I have multiple sheets with three columns each:
Invested Amt, and
Return Amt. I am trying to merge the values and get a
Result dataset to create a single stacked line chart of
Invested vs Return against
Update: Demo sheet is available on, https://docs.google.com/spreadsheets/d/1mEQXW8202UsYkVzRVvZEbFrjzioDTB7KFDKQNy4zgEo/edit?usp=sharing
So my questions are,
- How to combine these values from multiple sheets to create a stacked line chart while taking care of the missing data?
- How to keep the final chart updated automatically when new rows are added the sheets?