I am trying to create a library of shapes with pre mapped data links.
What I would like to be able to do is to create a template and accompanying google sheet, that I can create multiple versions of and use this as a way to repeatably used the same shapes, in different diagrams, with each chart having its own unique set of data, without having to manually link each shape each time I produce a new chart.
I have tried everything I can think of, I have created a library of shapes, data linked but unless you are using copies of the same chart with the shapes already on the page pulling them from the library and then uploading the data DOES NOT work.
Even though the shapes in the library maintain the data fields, and identifiers and the data source uploaded has the exact same data and identifiers. I would really appreciate any help on this issue, I have been hitting my head against this for a little while now.
Is this just not possible? I feel it must be and there is something I am missing but I have watched every video, completed all the badges and looked and looked for a fix but cannot find one!