利用Excel绘制监测数据百分位数矩形图

Applying Microsoft Excel to Plot Percentile Boxplot for Monitoring Data

本文介绍了一种在Excel中绘制百分位数矩形图的方法,通过制作制图数据表模板和百分位数图模板,可方便地绘制基于不同站点或时段监测数据的百分位数矩形图,数据与图表自动链接,确保图形的准确,亦可根据需要对图形进行灵活的变换。

In this paper, a method to plot percentile boxplot using Microsoft Excel was introduced. By developing templates for datasheet and plotting, it was convenient to plot percentile boxplot based on the monitoring data from different monitoring stations in different time. Accuracy was ensured by the automatic link between data and plots. It allowed flexible adaptations of the plot to meet different requirements.