I am having trouble creating scatter charts in openpyxl. I have tried stripping everything back to be as simple as possible, and just creating a simple chart causes excel to identify the document as corrupt.
I have created a mockup of the script i am using, and it has the same issues - see attached. The script attached creates a simple enough excel file that excel is able to recover it by removing the chart (see excel error recovery log attached, although it isnt very helpful). The use case i am working with creates a document with large data sets on multiple sheets, with a chart on each. Excel is unable to recover these files.
I am using the following: Excel 2010, Python 3.6.1, openpyxl 2.4.7