Create editable box plots with mschart

[andrereh]

This package generates fantastic scatter plots that are editable in Word - even if they were produced on a Linux machine! I just wanted to ask if you're planning to implement box plots as well.

[JanMarvin]

Currently this is not possible as it requires a chart extension in the underlying spreadsheets, and this is not yet possible with mschart. However, some time ago I looked at what would be required to add this and I have a dummy implementation for openxlsx2 here: JanMarvin/openxlsx2#925

Still, the xml structure for this example is significantly different from what mschart uses today, and since a couple of my earlier extensions to mschart (#82 #84 ) were thoroughly neglected (😛), and because I have much better things to do than delve further into native spreadsheet diagrams (something along the lines of sitting on the couch and reading a book) - which is why I love mschart so much - I never extended it to a full pull request.

[andrereh]

Currently this is not possible as it requires a chart extension in the underlying spreadsheets, and this is not yet possible with mschart. However, some time ago I looked at what would be required to add this and I have a dummy implementation for openxlsx2 here: JanMarvin/openxlsx2#925

Still, the xml structure for this example is significantly different from what mschart uses today, and since a couple of my earlier extensions to mschart (#82 #84 ) were thoroughly neglected (😛), and because I have much better things to do than delve further into native spreadsheet diagrams (something along the lines of sitting on the couch and reading a book) - which is why I love mschart so much - I never extended it to a full pull request.

That's definitely a good starting point for a box plot implementation. Nonetheless, for my current project the plot would still require quite a lot customization, which is why at the moment I won't develop that idea further.