[Python] Is there a way to create Python figures that can be edited in Excel? [closed]

For a project, I need to create a lot of tables and figures (for multiple variables over multiple years). This can be easily automated. However, my client would like to receive editable figures in Excel, to be able to change the styling, such as colours, fonts etc. This is not negotiable. Here comes the problem, as I can't find a way to generate figures with Python which can be edited in Excel.

Solutions that I found so far include options to export figures as a picture or to be able to manually change the colour of a bar chart bar for bar (which is undoable for multiple figures).

My colleagues suggests to generate the tables with Python and make the figures manually. This seems rather time consuming to me.

Any suggestions to automate generating the figures and still be able to edit these in Excel?

Continue reading...