利用Excel组合图表达双层次局部与整体的关系——以异粒变速控释肥养分释放曲线为例

Applying Excel Compound Chart to Express the Double-leveled Relationship between Partial and Whole—Taking Nutrient Release Curve of Controlled Release Fertilizer Composed of Different Granule with Different Speed for Example

Excel软件的制图模块可较容易地表达单层次局部与整体的关系,但难以直接表达双层次局部与整体关系。该研究以异粒变速控释养分释放曲线为例,以双轴线-柱图为基础,通过修改部分数据系列的坐标轴和图表类型,成功制作了双轴线-堆积柱的组合图,较直观地展现了双层次局部与整体的关系,异粒变速控释肥养分释放曲线通过这类组合图可较明显地展现出基础控释肥对阶段释放率的贡献以及阶段释放率对累积释放率的贡献。

It is hard to repress the double-leveled relationship of partial and whole besides the single relationship. In this paper,nutrient release curve of controlled release fertilizer was taken as a example,which composed different granule with different speed,and a double axisaccumulative bar chart was introduced that based on the double axis-clustered column chart,in which chart type and coordinate axis of some data were changed. Then the contribution of base controlled release fertilizer to interval nutrient release rate,further more to accumulative release rate,so the double-leveled relationship of partial and whole was showed obviously.