[Python] Problem in generate charts by openpyxl using a high editon of python

I used python 3.7 + openpyxl to generated Charts ，It works well .

col chart created by python 3.7+openpyxl

But when I used a higher edition of python (3.8+) + openpyxl to generated Charts ，It works bad .

col chart created by python 3.13+openpyxl

so I search solution in google ，I find https://groups.google.com/g/openpyxl-users/c/khC6BTqaH3Y

It says remove " Compatible / Openpyxl" from app.xml in Excel file ，I try it ( change the extension from xlsx to zip ，change it and restore ) and it works ！

comparison in two file

I want to know whether it has command to turn off compatible or other method to solove the problem ？

Thank you !

Continue reading...