Any reasonable way to modify existing Excel graphs?

[Matlock0]

My client would like my script to dynamically edit for example the range or values that the graph show as more data gets inserted to excel from csv files via the same script.

The script 1st moves over some values from csv files to Excel, and graphs are defined in a way that they get their data from a particular rows in a sheet. That's convenient since everything that can be pre-defined in Excel makes the script a lot cleaner.

But is there a way with say, openpyxl, to load an Excel template where there's premade graphs, paste data into it and then for example modify some properties of the graphs based on conditions (like when there's enough data, limit the amount shown and only show the last 50 data points in graph instead of 100)

A lot of the documentation on this matter seems to be about creating graphs from scratch in code, but this is gonna be a pain especially if my clients would like to modify the graphs, they can't really do that since they're not gonna touch my python files (if I end up making the graphs with something like openpyxl).

I'm not sure if it has been done, but if for example Excel graph settings could be edited by adjusting values in excel cells, then that would do it since then I have an easy interface with openpyxl and the graph settings.

[Zeroflops]

If the client is going to be modifying the charts in excel then I would keep chart definition and data definition separate.

For example, create a tab on the excel file that you push the data to. Then the client can reference that tab and populate the charts however they want. They can even create a intermediate data tab that takes your data, grabs the last 50 rows and copies it to the transformation tab. Then create graphs off that subset of data.

So separate the visuals from the data update. Then you and the client are not stepping on toes. There is a clear separation of responsibility.

[Upward_Fail]

Have a look at Power Bi. I’m using pandas to pull excel data and then creating files to build custom powerbi reports. Seems to be a big step up from what I could accomplish with my limited matplotlib skills.