Hi,

I have charts in Word linked to charts in Excel. In the Excel I have in the same Sheet a lot of charts, most of them with several rows data and one to two columns.

I want to update data on the chart by adding new year=2021 in the row for every chart. When I go in Word, right click on a the first chart - Edit Data, and adding 2021 row in the Excel, everything works fine. But the problem occurs for the next chart, because Excel moves one row (added row in the pervious chart), so I get one more extra row in the second chart. Going further problem is getting bigger, because the last linked chart is moved by 100 or more added rows.

How to solve this problem?

Thank you for the help.