When the template with the charts is ready, the export should fill the Excel sheet with real data and the charts will automatically find their source data using named ranges.

For an example of defining exports with charts, see Template-with-charts.xlsx. That demonstrates how to filter the input data, alter the data during export, and define charts.