Forum Discussion
Structured Reference in diagram source
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 SergeiBaklan for your input, helped me to solve the issue!
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 SergeiBaklan for your input, helped me to solve the issue!