I am creating a line chart that contains multiple data series. In the picture below I'm showing the Chart editor of this line chart:

Every time I need to add more rows, I have to change manually the "400" value in each series. I am wondering if there is a way to create a reference to a certain cell value, so that I can just edit that cell value and have the "400" replaced with that cell value everywhere. Thank you.

CodePudding user response：

Make the range references one row taller, e.g., V11:V401, and insert new rows between rows 400 and 401.

Alternatively, delete all rows below row 400. The chart will automatically add new rows as they are inserted at the bottom of the sheet.