Named Range to Line Chart
I have been trying to add a named range as data to a line chart. The named range includes a range in a formula format, meaning:
=XLOOKUP(...):XLOOKUP(...)
Although the named range appears in the Excel output and is also able to be added as Series to a chart manually, I cannot do it directly from openpyxl. Is this feasible at all?