I'm afraid I don't have a OpenDoPE based solution for that.
In principle, you could either programmatically modify the chart data (which may be best where Office can then update the chart), or you could use a alternative approach to charts such as https://github.com/davidgohel/ReporteRs