Hi,
I have the issue that in previous used Office 2016 I could use sttructured reference for getting the dynamically changing data of tables into my diagram. This was very helpful as the diagram automatically showed all the rows data and not just a static number of them. Now with Office365 my structured reference get automatically replaced by the current static reference whenever I hit the apply button on the source selection for a diagram.
As I use diagrams in templates I do not want to put in a standard (always wrong) fixed number of rows for the diagram and then have to always adjust the source of every diagram in my file, whenever I use the template.
For better understanding I attached an example what happens to my structured reference when I click "ok" and reopen the source selection again.
Is there any solution for this issue, or did Microsoft just decide the once working structured reference for diagrams is not needed anymore?
Perhaps you may share some sample ? For example< I have such table
If I expand it Excel automatically expands data range
So I did some more digging and trying and my understanding now is that it works like pointed out by you, but doesn't work if your initial table has only one line of data. Because then the structured reference is not replaced by a series of cells but as a single cell reference.
So having one line of Data and adding more lines later does not result in expanding the series automatically. So my fix now is to have at least 2 lines of data in the initial table when creating the chart to bypass the issue of not expanding the series. Not a very nice/clear solution but it fixes my problem. Deleting the second row of data after the chart is created keeps the series alive, just creating the chart from only one line of data (with structured reference) doesn't work.
Thank you @Sergei Baklan for your input, helped me to solve the issue!
Accepted Solutions
So I did some more digging and trying and my understanding now is that it works like pointed out by you, but doesn't work if your initial table has only one line of data. Because then the structured reference is not replaced by a series of cells but as a single cell reference.
So having one line of Data and adding more lines later does not result in expanding the series automatically. So my fix now is to have at least 2 lines of data in the initial table when creating the chart to bypass the issue of not expanding the series. Not a very nice/clear solution but it fixes my problem. Deleting the second row of data after the chart is created keeps the series alive, just creating the chart from only one line of data (with structured reference) doesn't work.
Thank you @Sergei Baklan for your input, helped me to solve the issue!