WPS Office 2013个人版:[28]EXCEL做树木图表
1、安装WPS OFFICE软件,打开excel,并且新建一个空白文档。
![WPS Office 2013个人版:[28]EXCEL做树木图表](https://exp-picture.cdn.bcebos.com/3b8fb4d7726b0ce2b1993ebaef781423bfb9b6d7.jpg)
2、制作一个表格。A1输入【计划数量】,A2输入【100】;B1输入【实际栽种】,B2输入【85】。
![WPS Office 2013个人版:[28]EXCEL做树木图表](https://exp-picture.cdn.bcebos.com/9b2098254193cee8527a5eae5a0ff2260c9aa8d7.jpg)
3、【插入】菜单下的形状中找到三角形。
![WPS Office 2013个人版:[28]EXCEL做树木图表](https://exp-picture.cdn.bcebos.com/c255efc595ee41c14659a6e68d88912ca4ca9bd7.jpg)
4、制作出这两个图形,并且保存为图片,备用。
![WPS Office 2013个人版:[28]EXCEL做树木图表](https://exp-picture.cdn.bcebos.com/76b6860e5f204371a2a53c95323acd8921c58fd7.jpg)
5、把刚才做的表格做个图表,条形图
![WPS Office 2013个人版:[28]EXCEL做树木图表](https://exp-picture.cdn.bcebos.com/89402670d5413a8cad77afba1ffc508c9ace81d7.jpg)
6、注意选择:列
![WPS Office 2013个人版:[28]EXCEL做树木图表](https://exp-picture.cdn.bcebos.com/2947750192dd3340ad8c9b32881c99c0aefcf1d7.jpg)
![WPS Office 2013个人版:[28]EXCEL做树木图表](https://exp-picture.cdn.bcebos.com/359bee5e4a237971d7629c6d93196120a6cde3d7.jpg)
7、点击条形图标,右击,点击数据点格式
![WPS Office 2013个人版:[28]EXCEL做树木图表](https://exp-picture.cdn.bcebos.com/bab5c45872dade49567081e326042e6816e9d5d7.jpg)
8、并点击填充效果。
![WPS Office 2013个人版:[28]EXCEL做树木图表](https://exp-picture.cdn.bcebos.com/d9a8d2d2bb665159c03f1a9f8fe23ea23b42c7d7.jpg)
9、小图的设置。
![WPS Office 2013个人版:[28]EXCEL做树木图表](https://exp-picture.cdn.bcebos.com/a31e1214c27bd282d2f6abf33cb1eef97ebd36d4.jpg)
![WPS Office 2013个人版:[28]EXCEL做树木图表](https://exp-picture.cdn.bcebos.com/c8373cbc7dc5cf674f20dff38e96b814f5d026d4.jpg)
![WPS Office 2013个人版:[28]EXCEL做树木图表](https://exp-picture.cdn.bcebos.com/32fe25ef354f50b8c641a26edc4afa32929c18d4.jpg)
10、修改坐标轴的刻度。改为从零开始。
![WPS Office 2013个人版:[28]EXCEL做树木图表](https://exp-picture.cdn.bcebos.com/cf6d451b1edef4dcde4619aa45ecd3d968750cd4.jpg)
![WPS Office 2013个人版:[28]EXCEL做树木图表](https://exp-picture.cdn.bcebos.com/58021a0148fe1e42d4140e64c2299a88381303d4.jpg)
11、通过调整数字,可以看到效果。
![WPS Office 2013个人版:[28]EXCEL做树木图表](https://exp-picture.cdn.bcebos.com/acfda02f477046184ba5ee8eb08602214e5776d4.jpg)