在Excel中绘制学科成绩动态箱形图

Dynamic Box-plot of Subject Score in Excel

箱形图能提供有关数据位置和分散情况的关键信息,非常适合直观比较班级间学科成绩。可利用股价图间接绘制箱形图,并利用动态名称和控件实现动态变化。

The box chart can provide the key information about data location and dispersion, and it is suitable for the comparison between the class and the class subject. It can draw the box chart indirectly, and use the dynamic name and control to realize the dynamic change.