Excel中动态分析图表的几类制作方法

Several Methods of Making Dynamic Analysis Chart in Excel

相比于常规的静态Excel分析图表,动态分析图表由于其强大的灵活性,更适合职场中的数据展示。论文主要介绍如何利用辅助行、辅助列以及列表框、复选框控件制作动态分析图表。所做图表可以更好的实现数据切换和展示。

Compared with the conventional static Excel analysis chart, the dynamic analysis chart is more suitable for the data display in the workplace due to its strong flexibility. This paper mainly intro- duces how make dynamic analysis chart by using the auxiliary line, auxiliary column and the list ：box, check box control. The charts made by the method introduced in this paper can achieve better data switc- hing and display.