Excel sends a notification to other programs when data in a cell range has changed.
Due to a design limitation, described in Microsoft's knowledge base article KB2768406, Excel does not send a notification when data is copied and pasted within a workbook.
If you add a row or two of data to your spreadsheet, you can easily update the Excel chart pertaining to that data by changing the chart's data range.
However, if you find yourself continually changing the data range, you may want to set up the chart so that it automatically updates as new data is added.
The calculations are set on automatic for the workbook. I tried setting up an other chart in the same worksheet, linked to only one simple row and this new chart has the same refreshing issue so I suspect it has to do with settings or something like that but for the life of me I can't find which settings could do this.
Every time I want to see an updated version of it I have to either delete the serie and add it again or re-open the file.
The document uses many elements such as cross-references which must be updated before printing or posting online.
Now, the only way to get a crisp, clean chart in Word is to paste in using ctrl v.
Unfortunately, this also links the Excel file to the Word file, and makes the chart in Word update when changes are made to the Excel file.
However, when trying to update the chart seriescollection values and x Values I get subscript out of range errors.
Here is the C# code that I use to create the initial chart.