Create editable box plots with mschart
Opened this issue · 2 comments
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.
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.
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 foropenxlsx2
here: JanMarvin/openxlsx2#925Still, the xml structure for this example is significantly different from what
mschart
uses today, and since a couple of my earlier extensions tomschart
(#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 lovemschart
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.