charts from one google spreadsheet to another dynamically

1
votes
Google spreadsheet A with "sheet 1" - Master spreadsheet
Google spreadsheet B with "sheet 1"

There are charts in sheet B with source data in it. I want to import the chart to master spreadsheet B in such a way that, when the chart changes in sheet B, it should dynamically change in master sheet A too.

After a lot of research, I was able to find below:

  1. Importrange - imports the data only, and not charts
  2. copying the chart itself and pasting it to master sheet A, but it doesn't get changed when the chart is changing dynamically in sheet B.
  3. publishing the chart and inserting the URL as an image - this doesn't work if the master sheet A is google spreadsheet, but works for google docs, slides, etc. (correct me if I am wrong, as I tried and threw me an error)

For ease of explanation, I have given only two spreadsheets as an example. In the real case, I have one mastersheet, and 6 separate spreadsheets.

Any alternative suggested, or help is highly appreciated. Thanks

1
google-apps-scriptgoogle-sheets
Can you share sample example spreadsheets? It makes it easier to help when you do not have to create the example from scratch. – Urvah Shabbir
I went ahead and created the sample files. Your data range for sheet A might not be correct. Sheet A: docs.google.com/spreadsheets/d/… Sheet B: docs.google.com/spreadsheets/d/… On adding new entries in Spreadsheet B table, chart in Spreadsheet A is dynamically updated – Urvah Shabbir
@urwaCFC, Thanks a lot for your response, and efforts of putting together sample spreadsheets. I will keep that in mind to create sample sheets in future questions. I see what you have done, and i was able to achieve that myself(my bad, i didnt mention in my question). What i am trying to achieve here is, instead of importing the data from sheet B to A, i just want to directly use the source data from sheet B, and just create the chart in sheet A. – Bala
In other words, just the chart should be present in sheet A, and should pick up source directly from sheet B. The reason, the data from sheet B is huge, and i am planning on keeping close to 8 charts similar from different sheets(B,C,D,F,G,H). The mastersheet is slowed down due to enormous data. As a last resort i had planned to do the same you have demonstrated above(thanks a bunch once again), but i am still trying to see if there are any alternatives. – Bala

1 Answers

1
votes

Don't know your task but I found the answer to your question by using IMPORTAGE for data, then show the chart and hide the list where the data are shown