Hi,

I have a worksheet where I add new data by inserting rows at the top of the sheet. This works well for formatting (so I see most recent values at the top) but unfortunately breaks my charts on the sheet. This is because when I insert a row, the charts source data goes from this:

='Investment M&G'!$A$2:$B$745
To this
='Investment M&G'!$A$2:$B$2,'Investment M&G'!$A$4:$B$746

Does anyone know how I can always anchor the chart to the first source data statement such that I don’t always lose the top line of my data on the chart when I insert a row?