MS Excel - efficient way to create diagrams?

As part of one of my workflows, I would like to create an excel spreadsheet that includes diagrams.

My current way to do it is as follows:

• create excel file with diagrams manually,
• update data within file during workflow,
• automatically rename file and copy to output directory.

This works reasonably well for some cases but also poses problems. For example, I cannot figure out a way to dynamically change the range of the data referenced in the diagrams.

Thanks!