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.
Is there a better way which I haven't thought of yet?
Thanks!