① 打开Excel,选中需要制表的数据,点击“插入”->“数据透视表”
![](https://img2018.cnblogs.com/blog/1604302/201903/1604302-20190329085112210-1821533736.jpg)
② 出现下列对话框,点击“确定”
![](https://img2018.cnblogs.com/blog/1604302/201903/1604302-20190329085240901-1765621410.jpg)
③ 再新的“sheet”表内对“数据透视表字段”进行操作
![](https://img2018.cnblogs.com/blog/1604302/201903/1604302-20190329085308867-628156134.jpg)
![](https://img2018.cnblogs.com/blog/1604302/201903/1604302-20190329085318632-1534792569.jpg)
④ 选中任意数据透视表的内容,点击“分析”->“字段、项目和集”->“计算字段”,填写需要添加字段的名称和公式;(如果不需要添加字段,可忽略这一操作)
![](https://img2018.cnblogs.com/blog/1604302/201903/1604302-20190329085334875-736617619.jpg)
![](https://img2018.cnblogs.com/blog/1604302/201903/1604302-20190329085349770-1167727278.jpg)
⑤ 选中制表数据,点击“插入”->“推荐的图标”,自由选择自己想要制作的图像
![](https://img2018.cnblogs.com/blog/1604302/201903/1604302-20190329085404604-1714306660.jpg)
⑥ 下图是做的一份图表,可供参考(有下拉菜单的地方是可以选择性的产看数据的良率走势):
![](https://img2018.cnblogs.com/blog/1604302/201903/1604302-20190329085614047-1894476573.jpg)