In a spreadsheet with charts how do I make charts move down automatically with the old rows when I insert a new row above them?

In a spreadsheet with charts
how do I make charts move down automatically
with the old rows when I insert a new row above them ?

Job done - thanks

It should be enough to anchor the diagram to a cell.


If this answers your question, please click on the circle with the tick (✔) on the left (the point is highlighted in green and the answer is highlighted in color) so that other users can see that the question has been answered.

It certainly should. - Your reply helped me find the right button in the maze of settings - thanks

@sues, Don’t forget to check the mark (Answer markCorrect answer mark) to the left of the answer to show that your question was solved.