Question: how to do a boxplot in excel?
Answer: Select cells E3:G3 -- the heading cells -- then press Ctrl and select E10:G12. On the Excel Ribbon, click the Insert tab, and click Column Chart, then click Stacked Column. If necessary, click the Switch Row/Column command on the Ribbon's Design tab, to get the box series stacked.