Need help with boxplot

How are you making your "standard" box plot? If I understand what you want, it sounds like it should be the same as a basic box plot (I usually make them as stacked bar/column charts) with separate "categories" for L1 and L2 words. Can you upload a sample file with your current attempts at a box plot so we can see how you are building your box plot. I think that will make it easier to suggest adjustments to get what you want.

A picture in a Word document does not help me understand how you created the chart. It sounds like you may have used the built in box plot specialty chart type that is available in newer versions of Excel (I thought it was introduced later than 2010 -- are you still using 2010?).

I am going to assume you are using 2016 or later and you are using the built in box plot chart type (see help file here: https://support.office.com/en-us/art...8-4743f6190f0d ). The first thing I notice is that your source data is arranged different from the example in the help file. MSFT's example shows a table with course type (-> your word length?) going down the left side of the table, school (-> your language type?) across the top, and the corresponding values in the body of the table. A pivot table or Get and Transform should be able to rearrange the data into this kind of table arrangement without too much difficulty. Then, it looks like you should be able to create your box and whiskers plot from that table. Assuming you are using 2016 or later, I would try that.

If you are using anything earlier, then I would expect to use a stacked column chart according to instructions similar to this: https://peltiertech.com/excel-box-an...ams-box-plots/ Again, much of the work is in the spreadsheet computing the needed summary statistics.